SCOrch SSRS Reports

Orchestrator is great for many things (I use it all the time to automate my own tasks), but when it comes to reporting on your servers, runbooks, and activities you more often than not need to write your own reports or use the SQL queries to generate them manually. This collection of reports was put together to help me spot check the health of my servers and identify usage and failure patterns easier. The reports are based on a number of common Orchestrator SQL queries you find used to gather differents bits of information, this is simply an attempt to put more of those bits in one place. Once you have the reports setup you can configure a subscription to the 24 Hour Summary report, and you are off and running. The installation steps are included in the zip located here. (


Follow these steps to configure these reports.

1. Extract the Zip file locally.
2. Create a folder in SSRS to host the reports. (Typically /Orchestrator/<ServerName> to accommodate multiple Orchestrator servers.
3. Create a data source named 'SCOrch' in the folder and point it at your Orchestrator environment.
4. Upload the report files to the directory.
5. Start with the 24 Hour Summary Report to view the status of your environment.

Please send any questions or feedback to This email address is being protected from spambots. You need JavaScript enabled to view it..

Available for download here:

  • Created on .

IT/Dev 2014 Higlights

Here are my highlights from IT/Dev last week…


Kent and Johan's PreCon on ConfigMgr: Touched on a number of handy tips and tricks.  Links to all the goodies at located here.


CM Database still one file?: Ah poo, I setup my SQL database and it has all the data in one file.  Now what?  John Nelson has a blog post on correcting this and distributing your data into 4 files.


WSUS DB Cleanup: Kent covered the value of keeping the SUSDB clean for optimal query performance and minimal client data download when syncing the update catalog to the client.


Optimize Those Databases:  Steve Thompson discussed common pitfalls of the database maintenance tasks for CM.  Bottom line, don't trust the built in process.  More on his blog post here,


Microsoft One:  Mary Jo Foley discussed Microsoft's current business strategies.  On premise, clouds, AD, phone, .Net, and many others were discussed along with questions from the audience.  Follow her perspectives here:


Mimikatz:  How secure are your windows systems?  Try Mimikatz to understand what the bad guys can see when they get in by using this tool to help you identify security gaps:


SQL Query Superstardom for Beginners:  A fantastic introduction to the do's and don'ts for the 'accidental' DBAs that we can me have become as System Center admins.  What is sargable anyway?  (There is also a great presentation on indexing strategies)  Find out here.


  • Created on .

Purging Data from a SQL DB, Selectively.

I had this odd request to restore a database from backup, then clear all the data from the database with the excption of a dozen tables.  OK, I can do that but there is 1200 tables and I have other work to do too.  And you may notice from the tables it was the CM database.  So lets use a cursor against the list of tables and truncate some data!


declare @name nvarchar(256)

declare cur CURSOR LOCAL for


FROM sys.Tables

--Keep data in these tables

where name not IN('Computer_System_Data','Network_Data','PC_Bios_Data','Operating_System_Data','Processor_Data','PC_Memory_Data','System_Enclosure_DATA','Disk_Data','Video_Controller_Data','WorkstationStatus_DATA','SYSTEM_CONSOLE_USER_DATA','Add_Remove_Programs_64_Data','Add_Remove_Programs_Data','SoftwareFile','System_DISC')

open cur

fetch next from cur into @name



     EXECUTE ('TRUNCATE TABLE ' + @name)

       print 'Success: ' + @name



          print 'Failed: ' + @name

       END CATCH

    fetch next from cur into @name


close cur

deallocate cur


  • Created on .

Getting Started with Orchestrator

Nothing I love better than reference material.  And well, when I found this one last week I had to post something about it.  Gives a great overview of the nuts and bolts of Orchestrator.  And the best part is, only 186 pages long.  A great overview for anyone that wants to get jump started with System Center Orchestrator!

And to round out the other set of tools you need, just check the SCOrch site on CodePlex.  Great stuff to help you get rolling instrumenting Runbooks in a flash.

  • Created on .

Adventures in OS X - Part 1

Last week we had Chris Nacker's at our local user group to discuss MAC OS X management.  The SCCM client management on MACs is really basic at this time.  However since there is support for compliance, what you can do with it is really limited to your MAC shell scripting imagination as scripts can be used both to evaluate compliance and remediate it!  We recently started looking at managing OS X where I work.  Below are a few good like links to help you sift through the limited information that is out there on MAC OS X management with SCCM.

Client install -
Good Overview -
MAC OS X on VMWare -
Software Updates on OS X -

James Bannan has several good articles on his blog.... 

  • Created on .
  • 1
  • 2
Copyright © 2021 - The Twin Cities Systems Management User Group