Class security Level Vs Instance Level Security Rights You can configure the security rights either the class level or the…
Browsing: SCCM 2007
some times its hard to know the systems which are having issues in reporting their inventory and even some systems…
You can take a remote of any SCCM client by disabling the Firewall. But for security reasons/project requirement,the windows firewall…
Here are some webcasts related to ConfigMgr and deployment in general. ConfigMgr - Prerequisites Before Installation Installing SQL Server on…
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