Hi Team,We are migrating our fnms 2019 R2, on our stage and prod environment from OS 2012 to OS 2019 on app server, beacon and db server. We are retaining the same IP address and hostname for the OS 2019 as of OS 2012. While we did that on stage, we ...
Hi Team,I am looking for an DB table, which holds the information of list of applications which comes under the license. I have looked at the table SoftwareLicenseByApplication but it has fewer applications listed than what we see in the UI. Also the...
We already have an custom adapter to pull in the purchase order from the PO DB, we recently have the maintenance start date and end date added the PO DB which we want to import through the adapter to FNMS. On our existing adapter we have an staging ...
Is there a value with i can differentiate between both these at the DB on the softwaretitlelicense table or any other table in complicane DB holds this information. I am working an to extract only the main applications for the license, so need an va...
Hi Kclausen,The query lists all the possible applications which can be mapped to that license, but on the UI when we search for applications under each license it has two sections one as "Applications" and another one "Applications covered by upgrade...
Hi @anne_watson ,Thanks for your suggestion, i initially tried with enabling the maintenance and assigning the start dates and end dates as well on the same SQL statement as below.case when (po.[Maintenance_start_date]) is not null then 1 end as Main...
