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
CAST
CHARINDEX
clustered index seek
coalesce
constraint
CSV
CTE
execution plan
Export
GROUP BY
index
indexes
inline function
inner join
INT
itemExtract
left outer join
LIKE
Linked Server
list to column
Microsoft Systems Management Server
Microsoft.XmlHttp
multistatement table-valued function
order by
outlook
perfmon
performance tips
permissions
PIVOT
promisec
Query Performance
scalar-valued user defined function
SCCM
SCOM
scripting
service packs
shell scripting
SMS
sms 1.2
sms 2.0
SMS 2003
SMS 2003 SP2
SMS 2003 SP3
sms permissions
sms report
SMS Web Reports
SMS_INVENTORY_DATA_LOADER
SMS_SOFTWARE_INVENTORY_PROCESSOR
smsschm_users
sorting
SQL
SQL 2000
sql 2005
Status Messages
SUBSTRING
system center configuration manager
table
table scan
Table size
table variable
tables
temp table
Troubleshooting
TRUNCATE
UDF
udf_FormatBytes
udf_ItemExtract
udf_Split
UNC
user defined function
user defined functions
v_add_remove_programs
v_GS_SoftwareFile
v_GS_SoftwareProduct
v_ProductFileInfo
V_R_System
v_SecuredObject
v_StatMsgAttributes
v_StatMsgInsStrings
v_StatusMessage
v_UserClassPermissions
vbscript
view
views
web report
web reports
webreport
webreport_approle
wildcard
Winbatch
Windows
WQL
x64
News
Navigation
Site Home
Home
Bloggers List
Blogs
Photos
Downloads
Archives
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
»
SCCM
(
RSS
)
batch scripting
permissions
powershell
promisec
Query Performance
Schema
SCOM
scripting
shell scripting
SMS
SMS 2003
SQL
SQL 2000
sql 2005
system center configuration manager
UNC
vbscript
web report
web reports
Winbatch
WMI
SMS/SCCM vs Promisec Spectator - Part 2 of 2 (The rebuttal)
by
jnelson
If you read my previous post on the blood-boiling comparison between SMS/SCCM & Promisec Spectator, you've likely developed all kinds of responses in your head about how they're so wrong on...
Filed under:
SCCM
,
SMS
,
promisec
SMS/SCCM vs Promisec Spectator - Part 1 of 2 (Their Comparison)
by
jnelson
If you're an SMS or SCCM guy and you want to get your blood boiling, just look at this writeup the people at Promisec created that compares SMS to their Promisec Spectator. I mean no disrespect to...
Filed under:
SCCM
,
SMS
,
promisec
SMS/SCCM & Batch Files - Important notes on running .BAT files from UNC in SMS/SCCM
by
jnelson
THE PROBLEM When you run a .BAT file from a UNC path, the first thing you might notice is the warning about "UNC paths are not supported. Defaulting to the Windows Directory" All this really...
Filed under:
SCCM
,
SMS
,
shell scripting
,
batch scripting
,
UNC
SMS 2003 - Verify WMI Stability Backport on Windows XP/Server 2003 with this report SQL (deploy to them with this collection query WQL)
by
jnelson
BACKGROUND (click HERE to skip to the summary) I've been looking into our client health a lot deeper recently and something that I keep coming back to is how fragile WMI seems. After some great conversations...
Filed under:
SCCM
,
SMS 2003
,
web reports
,
WMI
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, SQL 2005 and higher. SELECT UCP.UserName, SO.ObjectName...
Filed under:
SCCM
,
web report
,
sql 2005
,
SQL 2000
,
permissions
,
system center configuration manager
M@d Skillz - Introducing a new degree of difficulty
by
jnelson
I've been getting some positive feed back on how much detail I've been putting into my posts and how appreciative people are that I include the full explainations for those people who don't...
Filed under:
SQL
,
SCCM
,
SMS
,
SCOM
,
shell scripting
,
Winbatch
,
batch scripting
,
powershell
,
scripting
,
vbscript
SMS/SCCM Query Performance Tips - Addressing objects with the schema name (.dbo)
by
jnelson
A commonly overlooked little performance tip in SQL is addressing your objects (like tables, views, functions, procedures, etc.) using the schema (aka, the owner) name in front of the object. For example...
Filed under:
SQL
,
SCCM
,
SMS
,
Query Performance
,
Schema