Converting a NS6 report to NS7
We are in the process of upgrading from NS6 to NS7. One of the main reports that we use is ARP by Owner's Department. I was wondering if anyone might be able to assist me with converting the report?
The SQL for the report is the following:
SELECT DISTINCT T1.[Name] AS 'Name', T0.[Name] AS 'Product Name', T0.[Version] AS 'Version', gd.[Department], gd.[Display Name] AS 'Owner', T1.[_ResourceGuid]
INNER JOIN [Inv_AeX_AC_Identification] T1 ON T0.[_ResourceGuid] = T1.[_ResourceGuid]
INNER JOIN [ResourceAssociation] ra ON T0.[_ResourceGuid] = ra.[ParentResourceGuid]
INNER JOIN [Inv_Global_User_General_Details] gd ON ra.[ChildResourceGuid] = gd.[_ResourceGuid]
AND gd.[Department] LIKE '%_department%'
Order by gd.[Department]
The Global Parameters that we use are:
Thanks in advance!