Browsing: SCCM Reports

select CS.name0 as 'PC name', WS.LastHWScan as 'Last HW scan Date' from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_WORKSTATION_STATUS WS on CS.resourceID =…

I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed…

some times its hard to know the systems which are having issues in reporting their inventory and even some systems…

This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory…

This Report will help you in identifying the collection that are member of any other parent collection. SELECT COL.CollectionID, COL.Name,…

Gives list of computers where Programs installed recently. SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM…

  Select  Sys.Name0, Sys.SMSID0, Sys.Domain0, Sys.SystemRole0 from dbo.v_GS_SYSTEM Sys Where   Sys.SMSID0 = @GUID Prompt for GUID: select SMS_Unique_Identifier0 from v_R_System

SELECT ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion, ISC.CategoryName, count(*) as ‘count’ FROM dbo.v_GS_Installed_Software_Categorized ISC WHERE ISC.FamilyName In (‘Unidentified’,'Uncategorized’) group by ISC.NormalizedPublisher, ISC.NormalizedName, ISC.NormalizedVersion,…