How to report the content of a Filter, to export as CSV
Did you already because not able to export or copy/paste (text) the content of a filter ? As we were able with NS6
With a report, we still are not able to copy/paste directly into Excel It is one our feature request to Symantec thanks to vote those:
- https://www-secure.symantec.com/connect/idea/bring-back-copy-clipboard-button-smp7-interface seems to be on the roadmap ?!
But at least, we are able to export as CSV, ouf !
It is explain "Howto" there... : http://www.symantec.com/docs/HOWTO21759
But I believe you will prefer this shorter version:
Here a sample displaying "sotware" typical filter: just replace (bold) the GUID of the filter (see property of the filter) & the "Sot Name" yours:
This sample show multiple lines for same pc if multiple versions same "soft", but just remove this (Inv_AddRemoveProgram) if required.
SELECT r.Guid AS '_ItemGuid', r.Name AS 'Resource', r.[User], r.CreatedDate, Inv_AeX_AC_Identification.[Client Date], r.[System Type], r.[OS Name], Inv_Global_User_General_Details.Email,
Inv_Global_User_General_Details.[Job Title], Inv_AeX_AC_Identification.[Last Logon User], Inv_AddRemoveProgram.DisplayName,
Inv_AddRemoveProgram.DisplayVersion, vItem.Name AS FilterName
FROM vItem INNER JOIN
CollectionMembership INNER JOIN
Inv_AddRemoveProgram INNER JOIN
vComputerEx AS r ON Inv_AddRemoveProgram._ResourceGuid = r.Guid ON CollectionMembership.ResourceGuid = r.Guid ON
vItem.Guid = CollectionMembership.CollectionGuid LEFT OUTER JOIN
Inv_Global_User_General_Details INNER JOIN
Inv_Global_Windows_Users ON Inv_Global_User_General_Details._ResourceGuid = Inv_Global_Windows_Users._ResourceGuid ON
r.[User] = Inv_Global_Windows_Users.UserId FULL OUTER JOIN
Inv_AeX_AC_Identification ON r.Guid = Inv_AeX_AC_Identification._ResourceGuid
WHERE (Inv_Global_User_General_Details.Email NOT LIKE '') AND (Inv_AddRemoveProgram.DisplayName LIKE N'Java%') AND
(CollectionMembership.CollectionGuid = 'cbe9791c-7ed3-4b05-9129-c04d61cc8a23')
ORDER BY Inv_AeX_AC_Identification.[Client Date] DESC