All advertisements with specific status : This report gives you all percentage count with specific status for all advertisement in your environment. In order to get the list of machines where it is advertised with specific status,this report has to be linked to default report i.e 106.It works with SCCM , if you want to run the report in SMS 2003 ,see below after this code. SELECT AdvState.AdvertisementID, AdvName.AdvertisementName, AdvState.LastStateName, AdvState.number AS 'Number of clients with this Status', ROUND(100.0*AdvState.number/SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1 END),1) AS 'Percent with this Status', SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1…
Author: Eswar Koneti
Here are the list of windows update error codes http://inetexplorer.mvps.org/archive/windows_update_codes.htm
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 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE sys.ResourceID not in (select sys.ResourceID from v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID where DisplayName0 = @displayname) Prompt for Displayname: select DisplayName0 from v_Add_Remove_Programs
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 will have X number of applications and if there are 100 clients in collection ,it will be 100*X will be huge list of excel spread sheet. 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,…
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 ,some times u might see error like "the requested software cannot be located ,the system might be in the process of transferring thse files try again later ' Resolution: Try looking into the CAS.log file and see what it says . In my scenario ,it gives me an error "Location update from LS for content C0100001.01 and location request …No…
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 also add the prompt value to ask for application name as well. Report to List all add and remove programs on Particular computer excludes software updates ? 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 for…
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 HKEY_LOCAL_MACHINE,strKeyPath,strValueName,dwValue msgbox "Remote Desktop is active!" If you want to activate on a list of machines ,u can use FOR loop until it fisnihes to activate on all machines 🙂