Home > Microsoft, SCCM > Resources Installed Date Report On SCCM 2007

Resources Installed Date Report On SCCM 2007

Hey All, This is My First post on this blog, My colleagues From Diplomat will Join us Soon.

And now for the issue presented, Say you want to list all your all OS’s by installed date, sccm offer you this for every version and not for all your operating systmes, So if you want your  report to look like this one:

All You need to do is creat new report and add This SQL statement:

SELECT     DISTINCT dbo.v_R_System.ResourceID, dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.InstallDate0,
dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, dbo.v_GS_OPERATING_SYSTEM.Caption0, dbo.v_GS_OPERATING_SYSTEM.Version0,
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0
FROM         dbo.v_R_System INNER JOIN
dbo.v_RA_System_IPAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_IPAddresses.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
WHERE     (dbo.v_R_System.Client0 = 1)

Thats It, Have Fun

Yair

Advertisements
Categories: Microsoft, SCCM Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s