Browse by Tags

All Tags » SQL Server » SQL (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...

What is old, then new again? ODBC by sthompson

Read the following blog entry, found this to be very fascinating. http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with...

Microsoft SQL Server 2008 Service Pack 2 - available by sthompson

Microsoft SQL Server 2008 Service Pack 2 is now available for download. Download Here Overview Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available...

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 change SQL Server date time fields for report display by sthompson

A recent question on myITForum regarding a report query for ConfigMgr 2007: In a SQL query how do I convert the data/time that is returned in 2010-04-11...

Using TSQL functions to split a delimited string by sthompson

Answered a recent question on the forums that I thought was worthy of a blog entry. Question Looking for a function or a method to basically take the following...
Filed under: ,

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...

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: , , ,

How do I use a wildcard for add remove program information? by sthompson

Question: What I really could use is report #96 ("Computers with specific software registered in Add Remove Programs"), that allows me to include...

How do I return all records when there are no matching rows in a joined table? by sthompson

Question from the myITforum list: Need some help from all you experts out there, I have created an SMS report for all machines in a particular collection...
Filed under: , ,
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems