Number2 Blog - myITforum - All Comments

re: SQL Function - Convert Bytes to KB, MB, GB, TB, PB or EB and format the output to human readable format

Lightshards — Sun, 03 May 2009 20:42:02 GMT

Nice...

Thank you for this information.

is Yottabyte Pronounced eye-owe-ta-byte'?

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

Number2 Blog - myITforum — Fri, 13 Mar 2009 19:16:18 GMT

UPDATE: This is an update to yesterday's post which used dynamic SQL to show missing hardware inventory

re: SMS 2003 - Query to pull logged on user records from all sources

Tom_Watson — Fri, 06 Mar 2009 11:30:39 GMT

I had a few more ideas for finding users. Take a look at the report at :-

www.myitforum.com/.../tm.htm

Additional sources include Software Metering, Environment - plus I mentioned a few others that could be leveraged (e.g. Profile List, Software Inventory) - but maybe in separate reports.

Regards,

Tom Watson

re: SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand

shadster — Wed, 11 Feb 2009 21:27:26 GMT

I think you are right...

i just need to bite the bullet

do you recomend a good resource for wql/sql 101?

book, url, cbt or other?

re: Troubleshooting 301 - Finding a needle (bad program) in a haystack (list of 150 programs) in 7 tries.

shadster — Wed, 11 Feb 2009 20:54:05 GMT

I like the rational... very clever

re: SMS 2003 - SQL to compare software on two systems

gkamenjati — Fri, 09 Jan 2009 19:05:40 GMT

john, can you send me how's the SQL variable @ResourceID1/2 statements look like?

my email is gkamenjati@valleywater.org

thank you.

re: Digital Decor - Digital Pocket Viewer - How to get it to work (DPCI: 056-13-0705) (ASIN: B001GN416O) (Catalog #: 11018416)

kbertrand — Tue, 30 Dec 2008 02:32:05 GMT

OMG - I thought I was a geek but never thought of pressing the damn button twice! Thank you so much for the information - now I can carry my pics with me!

Happy New Year!

re: SQL for SMS - Concatenate MAC addresses and IP Addresses into their own columns

Tom_Watson — Fri, 28 Nov 2008 10:28:43 GMT

Great tip. Easily missed.

re: SMS 2003 - Query to pull logged on user records from all sources

jnelson — Thu, 30 Oct 2008 18:04:15 GMT

What SQL do you think there is to write? I'm not getting what you mean...this is complete SQL that works when you put it into a report and prompt the user to enter a ResourceID. If you want to specify your own resourceID, replace @ResourceID with the ID you're looking for. If you mean you want SQL code for the ResourceID prompt...you don't NEED it, but if you want it you can get examples from the hundreds of reports that already prompt you for a resourceID. Just open up a report that you know prompts you for a resourceID and look at what they have for SQL.

re: SMS 2003 - Query to pull logged on user records from all sources

gkamenjati — Thu, 30 Oct 2008 17:47:02 GMT

Can you write the SQL (2005) for the @ResourceID?

feel free to email me gkamenjati@valleywater.org

Thank you #2.

re: Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND "&" in SQL)

jnelson — Thu, 30 Oct 2008 13:59:41 GMT

Yeah, that %,% thing...for some reason, I see a small handful off machines (30ish) that have multiple IP addresses in the same IPAddress0 field, separated by commas. I haven't put too much thought into why, and I didn't want to bother splitting them into separate IPs for this article, so I just excluded them.

re: Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND "&" in SQL)

Tom_Watson — Thu, 30 Oct 2008 12:20:17 GMT

Excellent post. Will save me going to www.subnet-calculator.com to figure out a basic subnet calculation.

One question - what is the last line for?

AND cfg.IPaddress0 NOT LIKE '%,%'

re: Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND "&" in SQL)

skissinger — Wed, 29 Oct 2008 20:19:27 GMT

Have fun with that!? You do know, John, that you have just a mildly twisted sense of fun, right? :-)

re: WQL - Using the bracket wildcard to match a range of version numbers (MNSCUG)

shahm1 — Mon, 20 Oct 2008 15:09:24 GMT

John,

Very nice article!

Great job again!

Manoj

re: SMS/SCCM vs Promisec Spectator - Part 2 of 2 (The rebuttal)

philippe67 — Fri, 12 Sep 2008 10:08:21 GMT

Hi,

How do you configure DCM to detect changes in a folder (subfolder creation/deletion) or a registry key (subkey creation/deletion) ?

Thank.

re: VBScript - (UPDATED) Script to export SMS Web report results to an Excel spreadsheet

jgilbert — Fri, 22 Aug 2008 23:08:03 GMT

Nice...I'm adding this to my bag of tricks.

re: SMS/SCCM & Batch Files - Important notes on running .BAT files from UNC in SMS/SCCM

scassells — Tue, 19 Aug 2008 15:02:40 GMT

This is a great post. It has been a long time since i've used %0 and the conjunction with text parsing from the For help is really creative.

Great job John

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

sthompson — Sun, 17 Aug 2008 15:18:31 GMT

Elegant solution!

re: VBScript - Script to export SMS Web report results to a CSV file

jnelson — Tue, 24 Jun 2008 14:33:20 GMT

Well, are you getting access denied running it manually yourself or only when you schedule it via scheduled tasks? I'd say first make sure your user account has rights to run a normal report on the server. Then make sure it has rights to run this modified asp on the same server. If all that works, then use the same account to schedule a report to be run to see if it's the user permissions or something else. If the account doesn't have rights to output to the file or folder you passed to it, that won't work either. So I guess, what's giving you the error? Can you post it?

re: VBScript - Script to export SMS Web report results to a CSV file

nihar — Tue, 24 Jun 2008 06:54:06 GMT

Hi,

But didn't succeed to schedule a SMS report to automate running/exporting data in .CSV format and getting a "access denied" error. I think it may be due to some authentication issue with my account.

In this Link, "myitforum.com/.../ExportSMSReport.txt", I found some prerequisites for automating the task of running/exporting a SMS Report to .CSV file.

Requirements: Ability to run vbscript using CSCRIPT 'Access to "Microsoft.XmlHttp" which I believe is part of MSXML and thus IE.' Access to "ADODB.Stream" for saving the binary output properly' An account with rights to run SMS Web reports ' Ability to write a CSV file to a folder on the machine running this script.'

Please suggests what are the permissions required to perform these tasks... Please help me...

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

bmason505 — Fri, 20 Jun 2008 00:35:37 GMT

Sexy. Never, ever go back to Oracle.

SMS 2003 - Verify WMI Stability Backport on Windows XP/Server 2003 with this report SQL (deploy to them with this collection query WQL)

Number2 Blog - MyITForum.com — Thu, 05 Jun 2008 13:05:15 GMT

BACKGROUND (click HERE to skip to the summary) I've been looking into our client health a lot deeper

SMS 2003 - Verify WMI Stability Backport on Windows XP/Server 2003 with this report SQL (deploy to them with this collection query WQL) - Number2 Blog - MyITForum.com

Thu, 05 Jun 2008 13:05:12 GMT

Pingback from SMS 2003 - Verify WMI Stability Backport on Windows XP/Server 2003 with this report SQL (deploy to them with this collection query WQL) - Number2 Blog - MyITForum.com

Audit Remote Tool Usage in ConfigMgr 2007

Chris Stauffer at myITForum.com — Wed, 04 Jun 2008 16:18:21 GMT

At my job we Audit Remote Control so that if someone is somewhere they are not suppose to be there is

Report for SMS 2003 and SCCM 2007 Security by John Nelson

Chris Stauffer at myITForum.com — Fri, 30 May 2008 18:01:15 GMT

SMS Permissions matrix myitforum.com/.../117881.aspx SCCM Permissions

Report for SMS 2003 and SCCM 2007 Security by John Nelson

Chris Stauffer at myITForum.com — Fri, 30 May 2008 18:01:04 GMT

SMS Permissions matrix myitforum.com/.../117881.aspx SCCM Permissions

re: M@d Skillz - SMS Status Messages - ASP to show all MessageIDs and their meanings

deepak — Thu, 22 May 2008 08:56:12 GMT

This is a fine piece of reverse engineering. I can help resolve some of the mystery. These messages are actually stored as message table resources in CLIMSGS.DLL, PROVMSGS.DLL, and SRVMSGS.DLL files on the site server. If you open these DLLs using a PE resource editor (I use a free tool "CFF Explorer") you can see all of them. The only reasonable way to directly get at these messages through code is to use the FormatMessage Windows API, which is probably what SMSRPHost.SMSReporting is doing for you.

re: VBScript - Script to export SMS Web report results to a CSV file

jnelson — Thu, 15 May 2008 04:16:10 GMT

Hmm, well I just don't know about that. I only wrote this to solve the SMS web report problem to mimic the subscribing in SSRS. I haven't looked into the way SSRS is doing it's posts and responses to know if it's similar enough to do the same thing with it. But if you have SSRS, then why would you have SSRS disabled? That's one of the great benefits! You've got the power to subscribe to reports right there, so use it! (I'm betting it's something political.

re: VBScript - Script to export SMS Web report results to a CSV file

riles01 — Wed, 14 May 2008 22:33:18 GMT

This was a great and very helpful script. I tried converting it to work with SSRS since I subscribing has been disabled; however, I get the following error:

"The path of the item 'fReportCurrent' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath) Get Online Help"

If I just type in the url, I can get the report just fine, but I have to click OK to save the file. Is that the part that's missing? I can't find anything else on this issue.

Thanks!

VBScript - (UPDATED) Script to export SMS Web report results to an Excel spreadsheet

Number2 Blog - MyITForum.com — Wed, 02 Apr 2008 07:58:38 GMT

BACKGROUND In a previous post I created a VBScript in response to a discussion in the forums where somebody