Usually when applications are installed,they wont repot to site server with installed software and its details why because the value that should report to site server is not picked by sms agent by default and you should edit SMS_DEF.MOF file which you find it from your site server installed drive,inbox folder,clifiles,hinv . Below is the group to make TRUE from FALSE to get the requirement information. You dont have to compile this mof file on clients as they get it by its next policy cycle. Monitor the MOF Changes from site server logs (dataldr.log) SMS_Report (FALSE), SMS_Group_Name ("Installed Software"), …
Author: Eswar Koneti
SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007' WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010' ELSE 'Udda Version' END AS 'Office Version', a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID WHERE FileName = 'outlook.exe' AND ( c.System_OU_Name0 LIKE 'groupinfra.com/Corporate/Landlord SE/SE/Computers%' OR c.System_OU_Name0 LIKE 'groupinfra.com/Corporate/Landlord SE/DK/Computers%' OR c.System_OU_Name0 LIKE 'groupinfra.com/Corporate/Landlord SE/FI/Computers%' OR c.System_OU_Name0 LIKE 'groupinfra.com/Corporate/Landlord SE/NO/Computers%' ) GROUP BY b.Netbios_Name0, b.User_Name0, a.FileName, a.FileVersion, a.FilePath ORDER BY b.Netbios_Name0
SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet FROM dbo.v_SiteRoamingBoundary_IPSubnet) GROUP BY IP_Subnets0 ORDER BY IP_Subnets0
Long back have posted how to download prerequsisits which are required for configMgr 2012 RC1 http://eskonr.com/2011/10/configuration-manager-2012-prerequisites-download/ . Day ago there was ConfigMgr 2012 RC2 released with some modifications ,avilable here to download ConfigMgr 2012 RC2 http://eskonr.com/2012/01/configmgr-2012-rc2-released/ . In ConfigMgr 2012 RC1 we have 13 files are prereq where as in RC2 we have 25 files as prereq. This post will gives you how to download the prerequsists files for ConfigMgr 2012 RC2. you can run SETUPDL.EXE from your command prompt (run with Administrator) with command line to download the prereq files on physical system and then load them into Lab server. Drive letter:\ConfigMgr_2012_RC2_ENU_7703\SMSSETUP\BIN\X64\setupdl.exe…
If you want to remove the registry key from local machine from windows 32 Bit OS (it will also remove the values residing in the key),try the below script as adminstrator (RUN AS). If you are using any deployment tool like Configmgr ,create a folder and place this script inside it and create a package by mapping the source as this folder and program command line as scriptname ,Run with administrative rights . Script to remove the reg key: const HKEY_LOCAL_MACHINE = &H80000002 strComputer = "." Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &_ strComputer & "\root\default:StdRegProv") strKeyPath = "SOFTWARE\Microsoft\Windows\CurrentVersion\Authentication\PLAP Providers\{11660363-8F14-CA1D-BB17-814630A2009F}" oReg.DeleteKey…
System center configuration Manager 2012 RC2 is released and avilable to download now. It will be available from the System Center Eval Center: http://technet.microsoft.com/en-us/evalcenter/hh505660.aspx I have tried it downloading but i can see other components along with System center configmgr 2012 with all the links avilable to download. if you are looking for only System center configuration manager 2012 RC2, you can use this link to save time in downloading other components http://care.dlservice.microsoft.com/dl/download/3/4/C/34C7656A-F89E-473C-8CE0-21DA5DB0717C/configmgr_2012_RC2_ENU_7703.exe else you can pause/cancel from your download manager tool. Additional Resources Getting Started with System Center 2012 Configuration Manager Introduction to Software Updates in Configuration Manager Configuring Software Updates…
had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where a.ResourceID=b.ResourceID and b.IP_Subnets0 in ('192.168.10.0') group by a.name0,b.IP_Subnets0 You can include other subnet details if you need.
simple and straight forward report that gives you the computers with operating system,CSD version(service Pack),Version number,OS Installed date,LastBootup time.windows Directory etc. You can customise this by adding additional colums http://technet.microsoft.com/en-us/library/dd334593.aspx and Creating Custom Reports By Using Configuration Manager 2007 SQL Views http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052 Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0 from v_R_System SYS join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID order by SYS.Netbios_Name0