You might get a request to find out all the computers in organisation connected to which printers.There might be differetn…
Browsing: SMS
You might have different operating Systems installed on the computers.One fine day your boss might request you to get list…
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…
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