Number2 Blog - myITforum
Sign in
|
Join
|
Help
Home
Contact
About
RSS
Atom
Comments RSS
Search
Tags
add remove programs
add_remove_programs_64_data
Add_Remove_Programs_Data
aliases
batch scripting
BIGINT
bitwise and
byte conversion
case
CAST
CHARINDEX
clustered index seek
CM 2007
CM 2007 SP2
coalesce
configmgr
constraint
CSV
CTE
Dynamic SQL
execution plan
Export
GROUP BY
hardware inventory
index
indexes
inline function
inner join
INT
itemExtract
Microsoft Systems Management Server
Microsoft.XmlHttp
mif
multistatement table-valued function
ObjectType
optimization
order by
outlook
perfmon
performance tips
permissions
PIVOT
promisec
Query Performance
scalar-valued user defined function
SCCM
SCCM Guru
SCCM Guru Webcast
Schema
SCOM
shell scripting
SMS
sms 1.2
sms 2.0
SMS 2003
SMS 2003 SP2
SMS 2003 SP3
sms report
SMS Web Reports
smsschm_users
sorting
sp_recompile
SQL
SQL 2000
sql 2005
SQL 2008
SQL Reporting Services
Status Messages
SUBSTRING
system center configuration manager
table scan
Table size
table variable
TRUNCATE
UDF
udf_ConvertBytes
udf_ItemExtract
user defined function
user defined functions
v_add_remove_programs
v_GroupMap
v_GS_SoftwareFile
v_GS_SoftwareProduct
v_ProductFileInfo
v_SecuredObject
v_StatMsgAttributes
v_StatMsgInsStrings
v_StatusMessage
v_UserClassPermissions
vbscript
view
views
vSMS_Folders
web report
web reports
webreport
webreport_approle
wildcard
Winbatch
WQL
News
Navigation
Site Home
Home
Bloggers List
Forums
Blogs
Photos
Downloads
Donate
Archives
September 2011 (8)
August 2011 (4)
June 2011 (2)
January 2011 (1)
October 2010 (1)
January 2010 (1)
December 2009 (1)
November 2009 (2)
October 2009 (4)
September 2009 (1)
August 2009 (3)
July 2009 (5)
March 2009 (2)
January 2009 (1)
December 2008 (1)
October 2008 (4)
August 2008 (6)
July 2008 (1)
June 2008 (2)
May 2008 (3)
April 2008 (2)
March 2008 (4)
February 2008 (1)
January 2008 (4)
December 2007 (7)
November 2007 (9)
October 2007 (7)
Browse by Tags
All Tags
»
SQL 2000
(
RSS
)
bitwise and
case
FOR XML PATH
GROUP BY
index
ip address
mac address
order by
permissions
PIVOT
SCCM
SMS
SMS 2003
sms report
SQL
sql 2005
system center configuration manager
UDF
user defined function
v_SecuredObject
v_StatMsgInsStrings
v_StatusMessage
v_UserClassPermissions
view
web report
web reports
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...
Filed under:
SCCM
,
web report
,
sql 2005
,
SQL 2000
,
permissions
,
system center configuration manager
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...
Filed under:
SMS 2003
,
web report
,
sql 2005
,
SQL 2000
,
permissions
Update - Rewritten for SQL 2000 - SMS 2003 - Getting information about advertisements when package or ad has been deleted
by
jnelson
Apparently there are enough people that still have SQL 2000 that I get hounded with questions whenever I post something that only works on SQL 2005, which...
Filed under:
PIVOT
,
index
,
GROUP BY
,
web reports
,
SQL 2000
,
v_StatusMessage
,
v_StatMsgInsStrings
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...
Filed under:
SQL
,
SMS
,
UDF
,
SMS 2003
,
web report
,
sql 2005
,
SQL 2000
,
ip address
,
mac address
,
user defined function
,
FOR XML PATH
,
sms report
M@d Skillz Update - Revised for SQL 2000 - Manual PIVOT
by
jnelson
You know, I got to thinking about yesterday's first-ever M@d Skillz article after Tom Watson lamented the fact that he's got SQL 2000 and it could...
Filed under:
SQL
,
PIVOT
,
web report
,
order by
,
GROUP BY
,
v_UserClassPermissions
,
v_SecuredObject
,
view
,
bitwise and
,
case
,
SQL 2000