Steve Thompson
Better living through automation :)
Sign in
|
Join
|
Help
Home
Contact
About
RSS
Atom
Comments RSS
Search
Tags
BIDS
ConfigMgr
ConfigMgr 2012
ConfigMgr R2
ConfigMgr R3
DCM
DDPS
MAP
MDOP
Misc
MMS
MMS 2009
MMS 2010
MMS 2011
MMS 2012
MVP
NAP
PowerShell
Report Builder
Reporting
Robotics
SCCM 2007
Scripting
Security
Server 2008
SMS 2003
Software
SQL
SQL Server
SQL Server 2008
SQL Server 2008 R2
SSAS
SSIS
SSRS
User Group
VBScript
Virtual Machines
Virtualization
Visual Studio
Win 7
News
Navigation
Site Home
Home
Bloggers List
Forums
Blogs
Photos
Downloads
Donate
Archives
January 2012 (1)
December 2011 (1)
November 2011 (2)
October 2011 (3)
July 2011 (7)
June 2011 (2)
April 2011 (2)
March 2011 (2)
January 2011 (4)
December 2010 (1)
November 2010 (1)
October 2010 (5)
September 2010 (1)
August 2010 (2)
July 2010 (5)
June 2010 (1)
May 2010 (6)
April 2010 (2)
March 2010 (2)
February 2010 (5)
January 2010 (2)
November 2009 (2)
October 2009 (3)
September 2009 (6)
August 2009 (3)
July 2009 (5)
June 2009 (3)
May 2009 (4)
April 2009 (3)
March 2009 (2)
February 2009 (2)
January 2009 (4)
November 2008 (2)
October 2008 (3)
September 2008 (7)
August 2008 (7)
July 2008 (2)
June 2008 (1)
March 2008 (3)
February 2008 (7)
Browse by Tags
All Tags
»
SQL Server
»
ConfigMgr
(
RSS
)
ConfigMgr 2012
ConfigMgr R2
ConfigMgr R3
Reporting
SCCM 2007
SMS 2003
SQL
SQL Server 2008
SQL Server 2008 R2
SSRS
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...
Filed under:
SQL Server
,
SQL
,
ConfigMgr
,
ConfigMgr 2012
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...
Filed under:
SQL Server
,
ConfigMgr
,
ConfigMgr R2
,
ConfigMgr R3
,
SQL Server 2008 R2
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...
Filed under:
SQL Server
,
Reporting
,
ConfigMgr
,
SSRS
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...
Filed under:
SQL Server
,
SMS 2003
,
SQL
,
ConfigMgr
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...
Filed under:
SQL Server
,
SMS 2003
,
ConfigMgr
,
SQL Server 2008
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...
Filed under:
SQL Server
,
SQL
,
Reporting
,
ConfigMgr
,
SSRS
,
ConfigMgr R2
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...
Filed under:
SQL Server
,
SCCM 2007
,
ConfigMgr
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...
Filed under:
SQL Server
,
SCCM 2007
,
SQL
,
ConfigMgr
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:
SQL Server
,
SQL
,
ConfigMgr
,
SSRS