Browse by Tags

All Tags » SQL Server » ConfigMgr (RSS)

Generate a list of Configuration Manager reports from Reporting Server by sthompson

Have you ever needed to product a list of reports and report descriptions from Reporting Services? Use the following SQL to retrieve this information from...

SQL Server 2008 R2 Service Pack 1 Released by sthompson

Note: This release is not yet officially supported for ConfigMgr 2007, once the product team completes their compatibility testing they will announce support...

Using Custom code in Report Builder by sthompson

As mentioned in an earlier post , it is possible to add custom code to Report Builder and BIDS (Business Intelligence Developer Studio).  There are...

How do I limit software in Add Remove Programs to specified subnets? by sthompson

Here is one solution to a recent question.  How do I limit the list of computers with specified software listed in add/remove programs to specific...

How to backup SQL Server system databases by sthompson

Most SMS/ConfigMgr administrators are aware of the importance of backing up the ConfigMgr database itself.  The recommended approach, is configuring...

Custom Software Update Compliance Report for ConfigMgr 2007 by sthompson

Had a special request recently to create a custom compliance report based on the selection of a software update list and collection name. Besides the columns...

Moving System Databases in SQL Server for ConfigMgr by sthompson

Have you ever had to move any of the following system databases: master, tempdb and/or msdb to another location? Be sure that you have a recent backup...

SQL Views documentation is Live! by sthompson

A while back, I was able to provide some assistance to Garth Jones in documenting the existing SMS/SCCM SQL Server views. Doug Eby, a Senior Technical...

SQL Server Reporting Services Resources by sthompson

I've recently finished an interesting project that made heavy use of SQL Server 2005 Reporting Services. As you are probably aware, Systems Center...
Filed under: , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems