Orchestrator 2012 R2 Installation Guide

Benoit LecoursOrchestrator, SCCM1 Comment

Here’s a guide to install a SCORCH instance on a single server. Use this setup for a lab, it’s not optimized for a production environment. Prerequisites Mminimum hardware configuration required for a full installation of Orchestrator: Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2 Minimum 1 gigabyte (GB) of RAM, 2 GB or more recommended 200 megabyte (MB) of available hard disk space Dual-core Intel microprocessor, 2.1 gigahertz (GHz) or better  SQL Specific SQL Server 2008 R2 or Microsoft SQL Server 2012 Orchestrator requires only the basic SQL Server features found in the Database Engine Service. Orchestrator supports SQL_Latin1_General_CP1_CI_AS for collation. Management servers and runbook servers installed on the same computer must use the same database  Windows Features IIS can be enabled manually but the setup will enable it Microsoft .NET Framework 3.5 Service Pack 1 Microsoft .NET Framework 4.5 (which further requires WCF HTTP Activation) Active … Read More

sccm query imported computer

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This sccm query imported computer might be helpful to know which user imported a specific computer. You add a new computer directly to the SCCM database by calling the ImportMachineEntry Method in Class SMS_Site. This can be used to deploy operating systems to computers that have not yet been discovered automatically by SCCM. You can view this information in the Status Message Queries and search for MessageID #30213. But this query will target only the information you need. You can use this query to create a report or directly in SQL MS. This query won’t work to create a collection since it’s SQL language. select CASE smsgs.Severity WHEN -1073741824 THEN ‘Error’ WHEN 1073741824 THEN ‘Informational’ WHEN -2147483648 THEN ‘Warning’ ELSE ‘Unknown’ END As ‘SeverityName’, smsgs.MessageID, smsgs.Time, smwis.InsString1 as Username, smwis.InsString4 as ComputerName, smwis.InsString5 as MAC from v_StatusMessage smsgs join v_StatMsgWithInsStrings smwis on smsgs.RecordID = smwis.RecordID join v_StatMsgModuleNames modNames on smsgs.ModuleName = modNames.ModuleName … Read More