if you want find out the computers that doesnt have particualr software installed in,you may write query where applications!=adobe which will not return the correct result as you would expect. you will have to use not in condition to get the correct result. here is you go: Select Distinct sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0 FROM v_R_System sys…

Report gives you all the installed applications excluding software updates .You can also customise to add other sec updates which you dont want them in report by adding  AND A.DisplayName0 NOT LIKE "name" at the end of report. SELECT A.DisplayName0,A.InstallDate0 A.Version0,A.Publisher0 FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B WHERE A.ResourceID = B.ResourceID AND A.DisplayName0 NOT LIKE ‘Hotfix…

Below listed the basic reports to display computers with particular add and remove application installed on computers. Report to list all the computers which have particular software/application installed ? SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like '%Adobe acrobat%' GROUP BY c.Name0, a.DisplayName0 ORDER BY c.name0 You can…

Here is a script that is used to activate/enable remtote desktop(RDP) on a local /remote computers. '*** Activates Remote Desktop on remote machine*** Const HKEY_LOCAL_MACHINE = &H80000002 'strComputer = "." strComputer = Inputbox ("Enter Computername:","Activate Remote Desktop","Computername") Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default:StdRegProv") strKeyPath = "SYSTEM\CurrentControlSet\Control\Terminal Server" strValueName = "fDenyTSConnections" dwValue = 0 oReg.SetDWORDValue…

SCCM 2007 OSD is a fantastic way to deploy operating systems; however, like most things SCCM, issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispersed nature of the blog posts that deal with some of these issues. This article will help SCCM OSD newbie’s with some of…

There are some warnings under component system for MP_control_manager bcz of client machine are not approved and MP is rejecting the policys that are requesting from the client (MP has rejected a policy request from GUID:d0400dcb-68a9-4b64-92af-daa70db2a53a because it was not approved. The operating system reported error 2147942405: Access is denied.) It might be difficult in…