Video Screencast Help
Search Video Help Close Back
to help

How to report the content of a Filter, to export as CSV

Created: 03 Oct 2012 | Updated: 03 Oct 2012 | 3 comments
Pascal KOTTE's picture
Pascal KOTTE Partner Accredited
+4 4 Votes
Login to vote

Did you already angry because not able to export or copy/paste (text) the content of a filter ? As we were able with NS6 crying

With a report, we still are not able to copy/paste directly into Excel no It is one our feature request to Symantec enlightened thanks to vote those:

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

 

Blog Entry Filed Under:
, , , , , , , , , , , , ,
Group Ownership:

Comments 3 Comments • Jump to latest comment

andykn101's picture
andykn101 Partner Accredited Certified
How to report the content of a Filter, to export as CSV - Comment:05 Oct 2012 : Link

I use this in a report:

SELECT TOP (100) PERCENT rc.Guid AS '_ItemGuid', id.Name AS 'Computer', gd.[Display Name] AS 'Primary User', MAX(cl.[Login Time]) AS 'Last Login', gd.Email

FROM dbo.RM_ResourceComputer AS rc LEFT OUTER JOIN
dbo.Inv_AeX_AC_Identification AS id ON id._ResourceGuid = rc.Guid LEFT OUTER JOIN
dbo.ResourceAssociation AS ra ON ra.ParentResourceGuid = rc.Guid AND ra.ResourceAssociationTypeGuid = '%Filter%' LEFT OUTER JOIN
dbo.Inv_AeX_AC_Primary_User AS pu ON pu._ResourceGuid = rc.Guid AND pu._id =
(SELECT TOP (1) _id
FROM dbo.Inv_AeX_AC_Primary_User
WHERE (id._ResourceGuid = _ResourceGuid)
ORDER BY _id DESC)

LEFT OUTER JOIN
dbo.Inv_Global_Windows_Users AS wu ON wu.UserId = pu.[User] LEFT OUTER JOIN
dbo.Inv_Global_User_General_Details AS gd ON gd._ResourceGuid = wu._ResourceGuid INNER JOIN
dbo.Evt_AeX_Client_LogOn AS cl ON cl._ResourceGuid = id._ResourceGuid INNER JOIN
dbo.CollectionMembership ON rc.Guid = dbo.CollectionMembership.ResourceGuid AND dbo.CollectionMembership.CollectionGuid = '%Filter%'

GROUP BY rc.Guid, id.Name, gd.[Display Name], gd.Email

ORDER BY 'Computer'

with a Query Parameter called "Filter", Type: "Basic Guid Parameter".

 

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: "Mark as Solution" posts that fix your problem, thumbs up for useful

0
Login to vote
Emil-Jose's picture
Emil-Jose
How to report the content of a Filter, to export as CSV - Comment:24 Apr 2013 : Link

Hello,

I created a simple report for this purpose, import the attached xml (report) to console and change the parameter to the filter you needed.

AttachmentSize
Filter Membership Report.zip 3.61 KB
+1
Login to vote
vikod's picture
vikod
How to report the content of a Filter, to export as CSV - Comment:09 May 2013 : Link

Guys!

You are GODS! 

Thank you so much!smiley

Cheers,

Vik

0
Login to vote