How to read the advertisement reports:- Accepted – Software can be installed in few mins, as it will start downloading the software from remote /local system No Status – Systems are not online or has issue with SMS Agent, or not received the policy, if the system is online then this status must change in … Read more
SQL Reporting services have some benefits over the current reporting solution: Provide best in class reporting capability by integrating SQL Reporting Services, with the leading change and configuration management product: SCCM 2007 Enable Ad-hoc reporting – Make it easy for both SCCM administrators, and non administrators to find the information they need to make the … Read more
For finding the 90 days old computers in the AD DSQUERY COMPUTER “DC=MydomainName,DC=COM” -STALEPWD 90 -LIMIT 5000 >> C:output.csv for finding the 90 days old computers in the AD & action to delete with the output DSQUERY COMPUTER “OU=COMPUTERS,DC=LANDESK,DC=COM” -STALEPWD 90 -LIMIT 5000 | DSRM -NOPROMPT >C:Output.csv
I recommend below ConfigMgr Reports to be familiar and these might be useful in day to day operations Asset Intelligence:- License 03A – Count of licenses by license statusHardware 07A – USB devices by manufacturer Software 02C – Software by Category and Family Software 01A – Summary of installed software in a specific collection … Read more
If you are receiving HTTP 500 Internal Server Error when accessing SCCM Reports via web browser, check the following settings: 1. Make sure that you are not hitting the limit of maximum rows returned by a report query. By default, report viewer in SCCM 2007 is configured to limit the results returned by a report … Read more
SELECT TOP (100) PERCENT ReportID, Name, Category, DrillThroughReportID FROM dbo.v_Report WHERE (NOT (DrillThroughReportID IS NULL)) ORDER BY ReportID
SCCM 2007 Search keys in the reports more than % We're all familiar with the "%" wildcard, However if you want more search like google…. then.. here are the tipsCheck this out (from the Admin guide): % (percent sign)Any string of zero or more characters. For example:Mo% searches for all names that begin with the … Read more
Client Custom Error Codes Error Code Description CCM_ERRORCODE(0x 80040200) NAMENOTFOUND2147746304 Name not found CCM_ERRORCODE(0x 80040201) BADNAMEFORMAT2147746305 Incorrect name format CCM_ERRORCODE(0x 80040202) SERVICESHUTDOWN2147746306 Service is shutting down CCM_ERRORCODE(0x 80040203) DATAEMPTY2147746307 No data supplied CCM_ERRORCODE(0x 80040204) DATATOOLARGE2147746308 Data too large CCM_ERRORCODE(0x 80040205) INVALIDPATH2147746309 Invalid path CCM_ERRORCODE(0x 80040206) INVALIDFILE2147746310 Invalid file CCM_ERRORCODE(0x 80040207) PARSE2147746311 Parsing error CCM_ERRORCODE(0x … Read more
List of all Virtual machines and their Physical host System Name This report lists all the virtual machines and also adds the PhysicalHostName0 property. This tells you the name of the host server the virtual system is sitting on. Here is the report syntax: SELECT distinct SYS.Netbios_Name0, Gvm.PhysicalHostName0, SYS.User_Name0, SYS.Resource_Domain_OR_Workgr0,OPSYS.Caption0 as C054, OPSYS.Version0, … Read more
Feature Comparison of MSDE and SQL Server 2005 Express While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express. Feature MSDE … Read more
