SMS - Number2 Blog

ConfigMgr/SMS - Query to enumerate the ProgramFlags (from v_Program) by jnelson

I know you've looked at the ProgramFlags field from v_Program and wondered what the heck those crazy numbers mean. Well, each bit (it's a 32-bit...

Filed under: SMS, configmgr, ProgramFlags, v_Program

SMS/ConfigMgr - Refresh/Recompile Views to Keep MetaData in Sync by jnelson

THE ISSUE SMS & ConfigManager (Microsoft Systems Management Server & Microsoft System Center Configuration Manager) are wonderful at dealing with...

Filed under: SCCM, SMS, sp_recompile, CM 2007, sp_refreshview

SMS 2003 - What do those C054 columns mean in reports? (Localized Name Lookup) by jnelson

If you look at certain pre-canned reports that come with SMS 2003, you'll notice some of them have wierd column names like C054, but show up in the...

Filed under: SMS, SMS 2003, web reports, v_LocalizedNameLookup

SMS 2003 - Query to pull logged on user records from all sources by jnelson

I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where...

Filed under: SQL, SMS, CTE

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

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

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

Filed under: SCCM, SMS, shell scripting, batch scripting, UNC

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

Filed under: SMS, sql 2005, web reports, Program Chaining, CTE, Common Table Expressions

M@d Skillz - Use data outside the SMS DB in your SMS Web Reports by jnelson

OVERVIEW (note: this is written with SMS 2003 & SQL 2005 in mind because that's the environment I'm in right now, but I believe if the equivalent...

Filed under: SMS, SMS 2003, web reports, ANSI_NULLS, ANSI_WARNINGS, External data, Linked Server, Heterogeneous queries, Distributed Queries, stored procedures

SMS 2003 Database - Where can I find things? by jnelson

Here is a list of common items that people want to query for and some locations they're found in the SMS database I'm basing this on SMS 2003,...

Filed under: SMS, SMS 2003, SMS Web Reports, web reports, views

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

Filed under: SMS, UDF, user defined functions, SMS 2003 SP3, SMS 2003, SMS 2003 SP2, Microsoft Systems Management Server, SMS Web Reports, web report, webreport, smsschm_users, webreport_approle, sql 2005, web reports, user defined function, sms report, sms 2.0, sms 1.2, list to rows, udf_Split, delimited list, list to table, list to column

Number2 Blog - myITforum

Search

Tags

News

Navigation

Archives

Browse by Tags