Limit SQL Report to a Collection

[dambrosioj]

I created this report to look for driver versions on our network after I edited the .mof file to look for it and everything seems to be pulling in great but I want to be able to limit this to a collection. Does anyone know how I can add that to this report.

 

 

 

 

SELECT

v_GS_NETWORK_DRIVERS.ResourceID

,v_GS_NETWORK_DRIVERS.DriverDate0

,v_GS_NETWORK_DRIVERS.DriverDesc0

,v_GS_NETWORK_DRIVERS.DriverVersion0

,v_GS_NETWORK_DRIVERS.WakeOnMagicPacket0

,v_GS_NETWORK_DRIVERS.RemoteWakeEnable0

,v_GS_NETWORK_DRIVERS.ProviderName0

,v_GS_NETWORK_DRIVERS.MediaType0

,v_GS_SYSTEM.Name0

FROM

v_GS_SYSTEM

INNER JOIN v_GS_NETWORK_DRIVERS

ON v_GS_SYSTEM.ResourceID = v_GS_NETWORK_DRIVERS.ResourceID

 

 

Thanks!

 

[GarthMJ]

This blog post will get you stated.

http://smsug.ca/blogs/garth_jones/archive/2014/01/13/limiting-a-report-to-a-collection.aspx

[dambrosioj]

This blog post will get you stated.

http://smsug.ca/blogs/garth_jones/archive/2014/01/13/limiting-a-report-to-a-collection.aspx

Thanks! I think I got it. Could you possibly help me add the model of the computer and PC Bios Version to this report?

 

SELECT

v_GS_NETWORK_DRIVERS.ResourceID

,v_GS_NETWORK_DRIVERS.DriverDate0

,v_GS_NETWORK_DRIVERS.DriverDesc0

,v_GS_NETWORK_DRIVERS.DriverVersion0

,v_GS_NETWORK_DRIVERS.WakeOnMagicPacket0

,v_GS_NETWORK_DRIVERS.RemoteWakeEnable0

,v_GS_NETWORK_DRIVERS.ProviderName0

,v_GS_NETWORK_DRIVERS.MediaType0

,v_GS_SYSTEM.Name0

FROM

v_GS_SYSTEM

INNER JOIN

v_FullCollectionMembership ON v_GS_SYSTEM.ResourceID = v_FullCollectionMembership.ResourceID

INNER JOIN v_GS_NETWORK_DRIVERS

ON v_GS_SYSTEM.ResourceID = v_GS_NETWORK_DRIVERS.ResourceID

WHERE (v_FullCollectionMembership.CollectionID = @collid )