Browse by Tags

All Tags » sql 2005 (RSS)

SMS/ConfigMgr - SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time by jnelson

INTEGER8... It's possible you're pulling a value from Active Directory for discovery like LastLogonTimeStamp which stores it's value as something...

SQL 2005 Security - Revoke EXECUTE rights for PUBLIC on (potentially) unsafe extended stored procedures by jnelson

Where I work, we have an amazing crew of security architects and analysts who have decades of experience in all things security. Sure, at times they may...

SMS Web Report (SQL 2005+) - Show SMS program execution chaining hierarchy visually using CTE (Common Table Expressions) in SQL 2005+ by jnelson

In response to a request on the forums, here's a SQL query that uses common table expressions (CTE) to visually return the program execution chain...

SCCM 2007 - SCCM Permissions Matrix by jnelson

This SQL query pulls all SCCM permissions for each user and displays them in a matrix. Put this into an SCCM Web report. This should work for SQL 2000...

SMS 2003 - SMS Permissions Matrix by jnelson

This SQL query pulls all SMS permissions for each user and displays them in a matrix. Put this into an SMS Web report. This should work for SQL 2000, SQL...

M@d Skillz - SMS Web Reports - Passing a delimited list to SMS Web Reports like a table - (also convert list to rows in SQL) by jnelson

BACKGROUND Pass multiple items into a single parameter? With SMS Web reports, there's a lot of power in being able to pass parameters to your report...

SMS 2003 - SQL Error: (SMS Message ID 620, SQL Message 2801) The definition of object 'sp_GetPublicKeySMSUID' has changed since it was compiled... by jnelson

PROBLEM Recently, we started seeing a TON of errors in SMS_DISCOVERY_DATA_MANAGER, SMS_INVENTORY_DATA_LOADER and SMS_SOFTWARE_INVENTORY_PROCESSOR (click...

SQL for SMS - Concatenate MAC addresses and IP Addresses into their own columns by jnelson

If you've ever written a report that also selects IP addresses or MAC addresses, you've noticed that there can be multiple addresses per machine...

M@d Skillz - SMS Permissions - BITWISE "AND" with a PIVOT thrown in for pretty :) by jnelson

M@d SKILLZ ARTICLE ALERT! (This is gonna get cr@zy, if you have a helmet, now's the time to put it on) So I was trolling the forums here on MyITForum...

SQL Oddity - OUTER JOINs with criteria act like INNER JOIN by jnelson

SYMPTOMS You have a query with an OUTER JOIN (aka LEFT JOIN, RIGHT JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN), and you need to put filter criteria on the...

SQL Performance - Indexes and the LIKE clause by jnelson

INDEXES AND THE LIKE CLAUSE Often times, people will make the generalization that when you have LIKE in your WHERE clause it won't use indexes. The...

SMS Web Report - Outlook machine counts by version (Plus a trick to order by version PROPERLY) by jnelson

RECOMMENDED READING First of all, you should read this article I wrote entitled " How to get the CORRECT order when sorting on version numbers like...

SQL for SMS/SCCM - How to get the CORRECT order when sorting on version numbers like xx.xx.xx.xx by jnelson

(UPDATE: This post was updated 2008-08-16. Skip to the end to see the update) THE PROBLEM Let's say you query SMS to find all versions of Outlook you...
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems