Groupe des Utilisateurs Altiris Suisses et Francophones Group

 View Only
Back to Library

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

Oct 03, 2012 12:13 PM

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

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Pascal KOTTE
Mar 09, 2015 06:39 AM

Thanks a lot ;-)

Migration User
Feb 21, 2015 05:48 PM

Thanks for this tip. Very useful.

David

Scott W. Allen
Feb 12, 2015 01:46 PM

Emil-Jose - thanks for sharing your report!

Migration User
Feb 06, 2015 12:01 AM

Emil-Jose, thanks for your report, it much helpful

amandaw33
Nov 05, 2013 01:07 PM

Emil-Jose - thanks for sharing your report!

Migration User
May 09, 2013 10:02 AM

Guys!

You are GODS! 

Thank you so much!smiley

Cheers,

Vik

Migration User
Apr 24, 2013 08:11 AM

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.

andykn101
Oct 05, 2012 01:07 PM

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".

 

Related Entries and Links

No Related Resource entered.