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…

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…