http://www.sqlmag.com/authors/author/author/5317830/rsscomment/5317830en-USFri, 25 May 2012 11:05:33 GMTFri, 25 May 2012 11:05:33 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorFri, 15 Oct 2010 12:03:15 GMT
Also , it would be great to link this to Visio and have some kind of visual diagram]]>WallaceFri, 15 Oct 2010 12:03:15 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorFri, 15 Oct 2010 10:51:02 GMT
Fantastic script. Is there anyway to only show DL nested groups and not security groups?]]>WallaceFri, 15 Oct 2010 10:51:02 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorTue, 02 Mar 2010 18:20:20 GMT
The problems in the article have been fixed. Thanks for letting us know about them, and thanks for reading! -Anne Grubb, web & developer editor, Windows IT Pro and DevConnections]]>AnneTue, 02 Mar 2010 18:20:20 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorTue, 02 Mar 2010 07:53:47 GMT
Cannot find Dowload the Code Here button!]]>DonTue, 02 Mar 2010 07:53:47 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorMon, 15 Feb 2010 22:44:49 GMT
First of all thanks for a great article. This type of thing is handy in dealing with compliance auditors. Second thanks for posting a script that’s not PowerShell. I’m finding people are adapting PowerShell to things where it doesn’t really fit just for the sake of being trendy. One piece of advice: Good AD administrators will have long, descriptive group names. I’ve had several issues with a similar .vbs bombing out over group names that exceeded the Excel’s character limitations. If you’re looking for a work-around to this there’s one here: http://www.ryanboyer.net/group-membership/. You’ll also find solutions for selectively auditing especially sensitive groups rather than every group across your (potentially) huge enterprise. Again - thanks for a terrific article. I keep subscribing to your magazine and interest groups because of useful articles like this one. -Tallarico Also - for]]>RYANMon, 15 Feb 2010 22:44:49 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorThu, 11 Feb 2010 10:02:14 GMT
Excel ran out of resources creating worksheets (Excel 2007; 4GB Win7); our AD contains 10’s of thousands of users; several forests, hundreds of OUs and thousands of groups. How can I modify the script to start with my OU and only enumerate groups within it? Excel can probably handle that much. I really like the article and concept and can really use the output if I can get it for our situation. thanks.]]>ShapardThu, 11 Feb 2010 10:02:14 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorWed, 03 Feb 2010 11:29:39 GMT
The link appears to be working now. Let me know if you’re still having problems with it. Thanks for your patience and reporting the error. -Anne Grubb, anne.grubb@penton.com]]>AnneWed, 03 Feb 2010 11:29:39 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorTue, 02 Feb 2010 18:00:22 GMT
Drat! I was looking forward to trying this out...come on guys get the link working please!]]>BILLTue, 02 Feb 2010 18:00:22 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorSun, 31 Jan 2010 15:22:39 GMT
Might be great...Please fix the download link!!]]>JohnSun, 31 Jan 2010 15:22:39 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorSun, 31 Jan 2010 13:45:49 GMT
Very good article. Now waiting for the script download to work;-)]]>RoaldSun, 31 Jan 2010 13:45:49 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorThu, 28 Jan 2010 06:54:52 GMT
I’ve let the editor know about the download link problem.]]>JAMESThu, 28 Jan 2010 06:54:52 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorMon, 25 Jan 2010 14:36:54 GMT
This might be very useful if the link worked]]>PhilMon, 25 Jan 2010 14:36:54 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorMon, 25 Jan 2010 08:22:16 GMT
Code dowload link broken ?]]>AndresMon, 25 Jan 2010 08:22:16 GMThttp://www.sqlmag.com/article/vbscript/document-your-domain-groups#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorWed, 23 Sep 2009 15:04:29 GMT
I’ve had several issues running the script - the last script error is Line 183 Char 2 There is no object on the server, Code 80072030. Unfortunately I’m not very versed in VB Script so I have terrible time trying to fix things that aren’t working for me. Any help would be appreciated.]]>JANISWed, 23 Sep 2009 15:04:29 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorMon, 31 Aug 2009 09:05:14 GMT
The script discussed in the article is AccountTracker.vbs, which you can access by clicking the “Download the Code Here” button at the top of the page. (You need to be a Windows IT Pro subscriber to see this button.) Unfortunately, on the current website, the only way to post a Reader Comment is to rate the article. Fortunately, the website is being redesigned. In the redesigned website, the Reader Comment and rating areas are separate, so you can post a Reader Comment without having to rate the article and vice versa. Karen Bemowski, senior editor, Windows IT Pro, SQL Server Magazine]]>KarenMon, 31 Aug 2009 09:05:14 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorFri, 28 Aug 2009 13:36:30 GMT
a script named adacctcountstoxl.vbs is mentioned in the print article but is nowhere to be found here. also, are authors & editors really allowed to rate articles when they post comments? wouldn’t that skew things a bit?]]>MarcFri, 28 Aug 2009 13:36:30 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scripts#commentsAnchorThu, 13 Aug 2009 10:46:00 GMT
I checked with Jim Turner about your question. He said that the Elevate Script HTA isn’t designed for logon scripts, so it wouldn’t work in your situation. He recommends that you call Microsoft Customer Service and Support because you might need to tweak some kind of Group Policy. Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenThu, 13 Aug 2009 10:46:00 GMThttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scripts#commentsAnchorhttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scripts#commentsAnchorWed, 12 Aug 2009 20:13:16 GMT
I am having this type of problem but with batch files which map network drives upon login to a Windows 2003 domain. XP runs them fine but Vista’s UAC won’t let them run. How can I do this same thing for these .bat files?]]>JonathanWed, 12 Aug 2009 20:13:16 GMThttp://www.sqlmag.com/article/permissions/utility-can-help-reduce-uac-headaches-when-working-with-scripts#commentsAnchorhttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loads#commentsAnchorThu, 23 Jul 2009 10:37:01 GMT
I sent your question to Jim. He noted that, "What the reader is assuming would also be what I would assume. Keep in mind though, that the intent of the script was to spot HIGH CPU utilization (on any processor). But yes, overall utilization, to the best of my knowledge would be an average of all CPU utilization." Thanks for reading Windows IT Pro! Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenThu, 23 Jul 2009 10:37:01 GMThttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loads#commentsAnchorhttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loads#commentsAnchorTue, 14 Jul 2009 10:03:16 GMT
On a server with 8 CPU’s what would be the best way to determine overall server load? Could I just add the results and divide by X where X is # of CPU’s? Is there a better method? Great Article.]]>RicardoTue, 14 Jul 2009 10:03:16 GMThttp://www.sqlmag.com/article/vbscript/a-refreshing-look-at-cpu-loads#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printers#commentsAnchorTue, 09 Jun 2009 10:29:46 GMT
I don’t know if it’s normal, but I can get printers from my print spooler cluster. Except that this is really great !]]>SYLVAINTue, 09 Jun 2009 10:29:46 GMThttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printers#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objects#commentsAnchorFri, 08 May 2009 10:42:06 GMT
My bad. It should work now. Comment here again if it doesn’t. And thanks! Caroline Marwitz Editor]]>CarolineFri, 08 May 2009 10:42:06 GMThttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objects#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objects#commentsAnchorFri, 08 May 2009 00:22:42 GMT
Unable to download the code!]]>AshleighFri, 08 May 2009 00:22:42 GMThttp://www.sqlmag.com/article/visual-basic-vb/active-directory-growth-tracker-a-script-to-count-objects#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printers#commentsAnchorWed, 29 Apr 2009 20:55:51 GMT
Just a small suggestion: when creating files with dates as part of the name, its often helpful to go for the order yyyymmdd (with or without separators) so that they can easily be sorted by date. Useful scripts though.]]>DuncanWed, 29 Apr 2009 20:55:51 GMThttp://www.sqlmag.com/article/html-application-hta/scripting-utilities-to-keep-tabs-on-your-printers#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-files#commentsAnchorMon, 16 Mar 2009 12:35:23 GMT
Hi x16wda, The information about the free text editors is helpful—thanks! If you (or anyone reading this) would like to share information about the free tools they like to use, you can send me a short description of what it does, where to download it, and how to use its main features. We feature a "Tool Time" column in the Reader to Reader" section of Windows IT Pro for such recommendations. If your write-up is selected for publication, it would get printed in the "Tool Time" column and you’d get $100. For an example of a "Tool Time" write-up, see "Tool Time: Test Connectivity to Remote Email Servers with TestMX" (http://windowsitpro.com/Windows/article/articleid/100732/100732.html) or "Tool Time: Copy Many Pathnames at Once With Path Copy" (http://windowsitpro.com/Windows/article/articleid/100962/100962.html) You can email the "Tool Time" write-up to kbemowski@windowsitpro.com or r2r@windowsitpro.com. Sincerely, Karen Bemowski, senior editor Windows IT Pro, SQL Server Magazine]]>KarenMon, 16 Mar 2009 12:35:23 GMThttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-files#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-files#commentsAnchorTue, 10 Mar 2009 20:05:26 GMT
Notepad is an awful application to use once the file size gets up to several megabytes. There are many free Notepad replacements out there, but most of them also fail miserably when confronted with a hundred-megabyte file. Fortunately there are several free text editors that aren’t fazed by big files. When I started needing to handle these beasts I did extensive research and testing on the available freebies. I primarily wanted fast large file handling capability, but I also looked for several extras.... line numbers, multiple document handling, column mode, etc. My current favorites are SciTE (http://www.scintilla.org/SciTE.html), ConTEXT (http://www.contexteditor.org/), and Crimson Editor (http://www.crimsoneditor.com/). They’re all capable of handling hundred megabyte files without choking and they have lots of features built in. Crimson Editor also includes a column mode, which is a lifesaver in some situations. I would also be remiss if I didn’t mention UltraEdit (http://www.ultraedit.com/), a commercial offering that has almost every feature you’d want. Coming from a Big Iron/ISPF background, though, I have to say that almost none of today’s text editors can do what IBM’s ISPF Edit could. If you are familiar with ISPF Edit and Rexx edit macros, you’ll understand what I’m saying - the power of that interface can make short work of complicated editing tasks. There have been several DOS-type clones of this environment, but they’ve been limited to an 80 by 24 screen and aren’t available any more. Now here’s the good news - Mizumaki-machi (sakachin2@yahoo.co.jp) has produced an ISPF Edit clone that takes advantage of Windows features like resizable screens! The program is called Hybrid Editor XE and it is FREE. There are two web sites for this program, http://hp.vector.co.jp/authors/VA010562 and http://www.geocities.jp/sakachin2/index.htm. You’ve got to try this out, just use the help since some commands have changed slightly from ISPF use.]]>BillTue, 10 Mar 2009 20:05:26 GMThttp://www.sqlmag.com/article/html-application-hta/divide-and-conquer-mega-sized-text-and-log-files#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorWed, 25 Feb 2009 03:23:55 GMT
If you are having problems accessing the article, please scroll down to the bottom of this page and click on Contact Us/Customer Service and let them know that you are having problems accessing the article with your subscription.]]>JAMESWed, 25 Feb 2009 03:23:55 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorWed, 11 Feb 2009 16:02:02 GMT
Where is the article? I have the same problem as floresj.]]>WayneWed, 11 Feb 2009 16:02:02 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorMon, 09 Feb 2009 19:46:40 GMT
I still cannot read the whole article after I subscribed.]]>JorgeMon, 09 Feb 2009 19:46:40 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorWed, 28 Jan 2009 15:18:05 GMT
The script discussed in the article--AccountTracker.vbs--is now in the 100428.zip file. You can access this .zip file by clicking the "Download the Code Here" button at the top of the page. Thanks for letting us know about the missing script--and thanks for reading Windows IT Pro! Karen Bemowski, senior editor, Windows IT Pro and SQL Server Magazine]]>KarenWed, 28 Jan 2009 15:18:05 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorWed, 28 Jan 2009 11:49:26 GMT
there is no script in the download just a text version of the call outs]]>vWed, 28 Jan 2009 11:49:26 GMThttp://www.sqlmag.com/article/auditing/track-active-directory-changes#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/happy-holiday-hta#commentsAnchorFri, 12 Dec 2008 12:27:33 GMT
Cute. ?]]>EmyFri, 12 Dec 2008 12:27:33 GMThttp://www.sqlmag.com/article/html-application-hta/happy-holiday-hta#commentsAnchorhttp://www.sqlmag.com/article/permissions/vista-s-uac-can-cause-problems-when-writing-and-running-scripts#commentsAnchorSat, 01 Nov 2008 12:18:17 GMT
how??! ...too bad i want to know the last thing mentioned...]]>April MaeSat, 01 Nov 2008 12:18:17 GMThttp://www.sqlmag.com/article/permissions/vista-s-uac-can-cause-problems-when-writing-and-running-scripts#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/using-setinterval-to-overcome-an-hta-shortcoming#commentsAnchorThu, 23 Oct 2008 20:30:42 GMT
Most interesting to see HTA’s being used by others.]]>leoThu, 23 Oct 2008 20:30:42 GMThttp://www.sqlmag.com/article/html-application-hta/using-setinterval-to-overcome-an-hta-shortcoming#commentsAnchorhttp://www.sqlmag.com/article/vbscript/build-directory-tree-structure-reports#commentsAnchorSun, 12 Oct 2008 14:58:40 GMT
lhjhgllklkhkhöökjjjjjjjjjjjjjjjogyughgdsssazeaxdfytri]]>NaveedSun, 12 Oct 2008 14:58:40 GMThttp://www.sqlmag.com/article/vbscript/build-directory-tree-structure-reports#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorSun, 12 Oct 2008 01:49:19 GMT
Hi, I am not able to run it.. its working for some of the machines and the servers but some time it prompts me following below error : Object required - Error 424 Terminating Program. Please guide me how i will solve this....]]>rishisana Sun, 12 Oct 2008 01:49:19 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorWed, 08 Oct 2008 09:51:51 GMT
Indeed very helpful tool. thanks]]>MagidWed, 08 Oct 2008 09:51:51 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/vbscript/use-an-hta-as-a-ui-for-your-vbscript-scripts#commentsAnchorSun, 05 Oct 2008 14:31:49 GMT
how do I see the entire article?]]>christopherSun, 05 Oct 2008 14:31:49 GMThttp://www.sqlmag.com/article/vbscript/use-an-hta-as-a-ui-for-your-vbscript-scripts#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorSun, 05 Oct 2008 10:33:02 GMT
Thanks for d nice tool.. I get mix result when querying product category...XP clients are good but I get a blank sheet for W2K3..under Installer_Installed]]>rocstaSun, 05 Oct 2008 10:33:02 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/vbscript/handy-htas-set-and-display-user-quotas#commentsAnchorWed, 01 Oct 2008 10:55:22 GMT
Where is the article ?]]>BasitWed, 01 Oct 2008 10:55:22 GMThttp://www.sqlmag.com/article/vbscript/handy-htas-set-and-display-user-quotas#commentsAnchorhttp://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-1#commentsAnchorTue, 02 Sep 2008 19:27:57 GMT
Finally I have found an article that clearly explains and demonstrates the basic workings of Excel! Thank You Logman98]]>WILLIAMTue, 02 Sep 2008 19:27:57 GMThttp://www.sqlmag.com/article/vbscript/using-ado-to-access-excel-part-1#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/using-setinterval-to-overcome-an-hta-shortcoming#commentsAnchorThu, 21 Aug 2008 14:41:46 GMT
Just what I needed. Thanks!]]>DanThu, 21 Aug 2008 14:41:46 GMThttp://www.sqlmag.com/article/html-application-hta/using-setinterval-to-overcome-an-hta-shortcoming#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorSat, 19 Jul 2008 03:28:22 GMT
Very bare bone but therefore very usefull to adjust to my own situation!]]>joanSat, 19 Jul 2008 03:28:22 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorSun, 23 Mar 2008 07:02:14 GMT
All links appear to be working at this time.]]>JAMESSun, 23 Mar 2008 07:02:14 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorSat, 22 Mar 2008 06:34:34 GMT
Download and Listing links are working. At least they are right now. If you notice problems like this please send a short statement via the "Contact Us\Customer Service" link at the bottom of this page.]]>JAMESSat, 22 Mar 2008 06:34:34 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorWed, 20 Feb 2008 20:54:20 GMT
Glad you liked the article. You can find another example of a mini-app in the article "Keep Your Favorite URLs Handy on the Desktop" (InstantDoc ID 97205). And if you have Windows Vista, you might want to check out "Go Go Gadgets" (InstantDoc ID 97019) which shows how to turn SysInfo.hta into a Vista Sidebar gadget.]]>kbemowski@scriptingprovip.com Wed, 20 Feb 2008 20:54:20 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorFri, 15 Feb 2008 16:10:58 GMT
FYI: You can find links to more Scripting Pro VIP articles about how to use Excel in scripts to produce customized reports in the article "Accelerate Your Ascent Up the Excel Learning Curve" (InstantDoc ID 96987).]]>kbemowski@scriptingprovip.com Fri, 15 Feb 2008 16:10:58 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorFri, 15 Feb 2008 14:17:00 GMT
Very good information.]]>CurtisFri, 15 Feb 2008 14:17:00 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorFri, 15 Feb 2008 14:07:09 GMT
An excellent tool to use... thanks]]>CurtisFri, 15 Feb 2008 14:07:09 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorThu, 17 Jan 2008 00:22:23 GMT
Both the links to Download code and ’Listing 1’ are broken. Both return "The network path was not found."]]>WILLIAMThu, 17 Jan 2008 00:22:23 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-5#commentsAnchorThu, 10 Jan 2008 11:14:08 GMT
Some have asked for an example of creating a Pivot Table using an External Source. Please see the Post in the General Discussion forum. http://community.scriptingprovip.com/forums/thread/29154.aspx]]>JAMESThu, 10 Jan 2008 11:14:08 GMThttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-5#commentsAnchorhttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorTue, 08 Jan 2008 22:06:14 GMT
Believe it or not, there is a reason behind using the year of 1601--and it’s not even a reason conjured up by Microsoft. We can blame the American National Standards Institute (ANSI) for this odd starting point. To find out why Microsoft uses the year 1601, see the note in the Scripting Guys article "Dandelions, VCR Clocks, and Last Logon Times: These are a Few of Our Least Favorite Things" at https://www.microsoft.com.nsatc.net/technet/scriptcenter/topics/win2003/lastlogon.mspx. The note appears toward the middle of the article.]]>KarenTue, 08 Jan 2008 22:06:14 GMThttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorhttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorSat, 22 Dec 2007 07:06:41 GMT
I agree, it is an unusual starting point. So Microsoft, why 1601?]]>JAMESSat, 22 Dec 2007 07:06:41 GMThttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorhttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorFri, 21 Dec 2007 21:50:55 GMT
This is certainly a good, by the book way to do it; Even though the base date (year 1601) is icrredibly silly. Nice work.]]>JoshuaFri, 21 Dec 2007 21:50:55 GMThttp://www.sqlmag.com/article/vbscript/using-date-related-attributes-in-saved-queries-#commentsAnchorhttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorWed, 14 Nov 2007 05:38:52 GMT
very good]]>victorWed, 14 Nov 2007 05:38:52 GMThttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorhttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorThu, 08 Nov 2007 18:18:51 GMT
ok]]>SteveThu, 08 Nov 2007 18:18:51 GMThttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorhttp://www.sqlmag.com/article/user-defined-function-udf/don-t-let-daylight-saving-time-sneak-up-on-you#commentsAnchorSun, 04 Nov 2007 17:13:32 GMT
Does this work for other timezones ? From skimming through the article I think it does as it’s using an offset of GMt but just wanted to confirm. Thanks, Johnny]]>johnnypowerSun, 04 Nov 2007 17:13:32 GMThttp://www.sqlmag.com/article/user-defined-function-udf/don-t-let-daylight-saving-time-sneak-up-on-you#commentsAnchorhttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorThu, 11 Oct 2007 21:49:07 GMT
ok]]>GThu, 11 Oct 2007 21:49:07 GMThttp://www.sqlmag.com/article/ldap/simple-saved-queries-for-active-directory#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorWed, 03 Oct 2007 17:45:27 GMT
Indeed very nice tool to use. Thanks.]]>KHALEDWed, 03 Oct 2007 17:45:27 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorFri, 14 Sep 2007 09:43:22 GMT
Very nice. I have my own version that i’ve used for years. I’ll have to update mine with some of your new functions.]]>JOSIAHFri, 14 Sep 2007 09:43:22 GMThttp://www.sqlmag.com/article/html-application-hta/system-inventory-mini-app#commentsAnchorhttp://www.sqlmag.com/article/monitoring-and-analysis/keep-tabs-on-your-administrative-group-memberships#commentsAnchorFri, 08 Jun 2007 17:57:23 GMT
How do I change from the rootdse to another domain? It seems nothing I input works. We have multiple domains. So I would like to run this script from my desk and point it to different domains.]]>La MarcFri, 08 Jun 2007 17:57:23 GMThttp://www.sqlmag.com/article/monitoring-and-analysis/keep-tabs-on-your-administrative-group-memberships#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorWed, 07 Feb 2007 23:47:03 GMT
very goood info..]]>radhikadear Wed, 07 Feb 2007 23:47:03 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-1#commentsAnchorTue, 30 Jan 2007 03:17:25 GMT
vERY USEFUL]]>ShainshaTue, 30 Jan 2007 03:17:25 GMThttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-1#commentsAnchorhttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-1#commentsAnchorTue, 30 Jan 2007 03:16:25 GMT
This is very more useful for my studies]]>ShainshaTue, 30 Jan 2007 03:16:25 GMThttp://www.sqlmag.com/article/vbscript/create-excel-reports-the-vbscript-way-part-1#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorTue, 16 Jan 2007 03:25:45 GMT
The full HTA application will be available in Part 2]]>JAMESTue, 16 Jan 2007 03:25:45 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorSun, 14 Jan 2007 04:26:07 GMT
To view or edit the code, open EventLogQuery.hta with a text editor such as notepad or if you have the application running, right click and select view source.]]>JAMESSun, 14 Jan 2007 04:26:07 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorWed, 10 Jan 2007 22:44:36 GMT
Some good information. I echo the thought that a full example would be helpful.]]>RichardWed, 10 Jan 2007 22:44:36 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorFri, 05 Jan 2007 12:00:09 GMT
Where are the codes? Only "Excerpt from EventLogQuery.hta" has been included]]>ThomasFri, 05 Jan 2007 12:00:09 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorThu, 04 Jan 2007 11:31:32 GMT
A good summmery. A full up example would help to show how it all goes together.]]>MikeThu, 04 Jan 2007 11:31:32 GMThttp://www.sqlmag.com/article/vbscript/exlerate-your-scripts#commentsAnchorhttp://www.sqlmag.com/article/vbscript/plan-ahead-for-patch-tuesday#commentsAnchorThu, 28 Dec 2006 11:35:49 GMT
The zip file doesn’t contain the code. It contains just the excerpt. And when I click the page 2 link on this webpage, page 2 doesn’t exist.]]>TestThu, 28 Dec 2006 11:35:49 GMThttp://www.sqlmag.com/article/vbscript/plan-ahead-for-patch-tuesday#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorSat, 25 Nov 2006 11:55:47 GMT
Jim, Thanks for the brilliant piece. Please hoW can I locate the complete application? I couldn’t find it on the InstantDoc #93973 as you advised. I will very much appreciate a speedy feedback. Many thanks again...]]>OlusegunSat, 25 Nov 2006 11:55:47 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/the-event-log-query-utility#commentsAnchorhttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorSun, 15 Oct 2006 01:47:07 GMT
If Not objItem.Started Or _ (objItem.Started And _ UCase(objItem.State) <> _ “RUNNING”) Then could be simplified: If Not ( objItem.Started And _ (UCase(objItem.State)==“RUNNING”)) Then]]>richardSun, 15 Oct 2006 01:47:07 GMThttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorhttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorFri, 06 Oct 2006 08:37:39 GMT
Great script.]]>KHALEDFri, 06 Oct 2006 08:37:39 GMThttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorhttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorThu, 05 Oct 2006 01:32:37 GMT
I subscribe to the hard copy of Windows Scripting and find it impossible to open the article. I end up at a form asking me to suscribe. What am I doing wrong?]]>richardThu, 05 Oct 2006 01:32:37 GMThttp://www.sqlmag.com/article/vbscript/programmatically-monitoring-a-service#commentsAnchorhttp://www.sqlmag.com/article/vbscript/produce-pivot-tables-programmatically#commentsAnchorMon, 28 Aug 2006 00:19:03 GMT
good]]>downbylhl Mon, 28 Aug 2006 00:19:03 GMThttp://www.sqlmag.com/article/vbscript/produce-pivot-tables-programmatically#commentsAnchorhttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/hta-f-x#commentsAnchorSun, 16 Apr 2006 16:08:08 GMT
While I have aspirations of learning higher level programming languages, I find HTAs facinating and very quickly provide for a user interface. This is especially true for providing other administrators access to my scripts without them having to rewrite scripts to fit their needs. Simply put, a more creative HTA interface is more user friendly and helps bridge the gap between a basic-level batch file and a more powerfull compiled application.]]>DENNISSun, 16 Apr 2006 16:08:08 GMThttp://www.sqlmag.com/article/windows-management-instrumentation-wmi/hta-f-x#commentsAnchorhttp://www.sqlmag.com/article/vbscript/hooked-on-htas#commentsAnchorFri, 14 Apr 2006 07:13:45 GMT
Thank you, thank you, thank you. As an MCSE (W2K) I find it necessary to blurr the lines between MCSE and MCSD. I’ll concede that scripting does not make a solution developer, but it sure makes my job much easier. I’ll be headed to the later HTA articles, as well as adding color to my reports ... wish me luck.]]>DENNISFri, 14 Apr 2006 07:13:45 GMThttp://www.sqlmag.com/article/vbscript/hooked-on-htas#commentsAnchorhttp://www.sqlmag.com/article/vbscript/use-an-hta-as-a-ui-for-your-vbscript-scripts#commentsAnchorWed, 15 Mar 2006 18:50:17 GMT
good]]>maprocksWed, 15 Mar 2006 18:50:17 GMThttp://www.sqlmag.com/article/vbscript/use-an-hta-as-a-ui-for-your-vbscript-scripts#commentsAnchorhttp://www.sqlmag.com/article/user-defined-function-udf/leapyear-function-might-have-you-leaping-for-joy#commentsAnchorWed, 01 Feb 2006 05:36:57 GMT
Very Cool and Creative! Much Cleaner and easier to debug than the code required were you to use the method: Every year divisible by 4 is a leap year, except if it’s divisible by 100 but not divisible by 400.]]>J.Wed, 01 Feb 2006 05:36:57 GMThttp://www.sqlmag.com/article/user-defined-function-udf/leapyear-function-might-have-you-leaping-for-joy#commentsAnchor