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…

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

In this blog post ,we will talk about how to get list of all applications installed on specific computer or at collection level  excluding software updates . Running the report on collection level will be huge report because each client…

I spent around 45 min to 1 Hour to find the root cause why it is happening though i have updated all the packages and use the correct TS. When you advertise a TS to refresh the Existing Operating system…

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 =…

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}!\\" &…

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…

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…

since few weeks i was working on  troubleshooting the inventory data loader issues on the client computers .Sometimes I get red Alert on the configuration manager Site status node for sms_inventory_data_Loader component. If you look at the monitoring node--site status--component…

Today ,i updated my SCCM SP1 site server to SP2 .I have listed the actions that might be helpful in doing so .It is strongly recommened that ,test it in testing environment before taking it to the production. It is strongly recommended  to follow the…