Add before the Order By WHERE 'your collection item' LIKE @CollectionID
From: [email protected] [mailto:[email protected]] On Behalf Of Iacaruso, Mike Sent: Wednesday, February 11, 2015 4:27 PM To: [email protected] Subject: [mssms] Prompt for collection in custom report Can anyone out there help me with this SQL query? This query works the way I want it but in trying to create a SCCM report based on it, I am having problems trying to figure out how to have a user select a collection for the report to run off of. I found several examples out there but I can't seem to figure out how to add the collection id to this query and from what sql table to use for the collection id. Thanks SELECT v_R_System.Name0 as 'Computer Name', v_GS_OPERATING_SYSTEM.Caption0 as 'Operating System', v_R_System.Client0 as 'Client', v_GS_AntimalwareHealthStatus.AntivirusSignatureUpdateDateTime, v_GS_AntimalwareHealthStatus.AntivirusSignatureAge, v_R_System.Last_Logon_Timestamp0, v_R_System.User_Name0 as 'Last User Logon' FROM v_GS_AntimalwareHealthStatus INNER JOIN v_R_System ON v_GS_AntimalwareHealthStatus.ResourceID = v_R_System.ResourceID INNER JOIN v_GS_OPERATING_SYSTEM ON v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID Order By v_GS_AntimalwareHealthStatus.AntivirusSignatureUpdateDateTime Mike Iacaruso Enterprise Desktop Engineer Office of Technology Services Towson University 410-704-3965 [email protected]<mailto:[email protected]>
