Browse by Tags

All Tags » configmgr (RSS)

ConfigMgr - Query to find all CM folders and show where they are in the console by jnelson

In response to a forum post, I've decided to write a quick article on getting folders from CM (and showing subfolder structure) and showing what kinds...

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

ConfigMgr - SRS Reporting - Use the "Format" Property To Format Numbers With Comma Separators by jnelson

THE PROBLEM You've written a SQL Reporting Services report (SRS) that displays large numbers (4 digits or higher). The problem is, end-users don't...

ConfigMgr 2007 - Where is v_GS_COMPUTER_SYSTEM_PRODUCT in CM? I think it's missing! by jnelson

If you're building reports in Configuration Manager 2007 like you did in SMS 2003, you may be looking for the view: V_GS_COMPUTER_SYSTEM_PRODUCT I...

UPDATE - ConfigMgr 2007 - Dynamic SQL to show missing hardware inventory by jnelson

UPDATE: This is an update to yesterday's post which used dynamic SQL to show missing hardware inventory in ConfigMgr. I noticed that we had like 95...

M@d Skillz - ConfigMgr 2007 - Dynamic SQL to show missing hardware inventory by jnelson

My fellow ConfigMgr MVP Torsten Meringer hit me up with an interesting question this morning. He wanted to identify those machines that are missing hardware...
Powered by Community Server (Commercial Edition), by Telligent Systems