VBS: Get old computer accounts from AD

UPDATED 2011-02-10: Added support for 33000+ records. Thanks to Mike for finding the limitation and testing the solution. (Note for 33000 records script takes about 1.5hrs to run)

The VBScript loops through the AD and lists all of the computer accounts in a csv file.

The Excel Code does the same except places the data in a formated table in excel, note it is only tested with excel 2007.

The following properties are returned:

  • Hostname,
  • Password Last Set,
  • Day Count (since password was last set),
  • Recent (was this done within the days specified in the script),
  • Disabled?,
  • Top Level OU,
  • OU,
  • Distinguished Name

Read More

SCCM Get Dell warranty info v2

2011-07-11: This method is now deprecated please go here: http://ninet.org/2011/07/dell-hp-warranty-info-in-sccm

LAST UPDATED: 2010-09-22

UPDATE 2010-09-14: Dell have changed the layout to add an extra field in the contracts section so the scripts are broken

UPDATE 2010-07-09: I’ve noticed this page is getting a lot of hits, I haven’t had a chance to get this working yet so if anyone does please post a comment or drop me a mail using the contact page. I’ll try and get some time next week to look at it again.

These scripts are a work in progress and you should check back regularly for updates until I mark them as final.

This is an updated version of the “SCCM Get Dell warranty info

Basically the problem with the other script is that a user with admin privs must run it or the computer account must have access to the internet.

I have split the script in 2 and rejigged it slightly so that now 1 (user) script is run “When user is logged on with the users privliges” and the other (system) script is run 2nd “When user is logged on with administrative privliges”. You can use the “Run another program 1st” option in the program definition which should make it practically act like a single script.

Read More

Infiniband cluster Part 1

Overview and installing the operating system

Intro:

To facilitate testing of our software and so that support can model possible customer environments I was tasked with setting up a cluster with infiniband. I was excited as the system was a Dell PowerEdge blade cluster (our 1st blade system) and we have never used or deployed infiniband (this would be our 1st infiniband system), in fact other than a basic “we have heard of this and know (very) roughly what it is” no-one in the group had any real knowledge of it. After a few hours of searching the deepest recesses of the Internet I had a limited understanding of how to setup the system. I know how irritating it is to have to read the crud in order to find that wee gem of info so from here on I’ll mark the paragraphs of the article so those of you wanting to “just get it done” can skip them.

Read More

SCCM Get Dell warranty info

2011-07-11: This method is now deprecated please go here: http://ninet.org/2011/07/dell-hp-warranty-info-in-sccm

LAST UPDATED: 2010-09-22

UPDATE 2010-09014: Dell have changed the layout to add an extra field in the contracts section so the scripts are broken

Version 2: work around for computer account that can’t access the internet http://ninet.org/2010/03/sccm-get-dell-warranty-info-v2/

I found a script and mof edit here: Sherry Kissinger’s Blog at myitforums.com

However when I tried it, it was completely broken all the data being returned in the wrong place. So I have rewritten it so that it is more modular and hopefully easier to maintain.

Now a bit of a disclaimer, my vbs skills are very rusty so the script works though it probably isn’t very efficient. So if you can suggest improvements please do and I’ll update the script as needed.

Although the code is long most of it is comments and “wscript.echo” statements for debugging, feel free to strip them out if you want something more compact.

I have also added the ability to dump the results to a csv file that you can collect with SCCM if you don’t want to capture from WMI.

Read More

Dell Scraper

Due to failings in the past, our inventory system is in need of a revamp as it is missing both systems and information as part of the revamp we decided to scrap everything we new and reinventroy everything. We use a lot of dell systems and I figured that as we had collected the service tags of a number of systems we could get the info about that system from the dell site. I wrote a quick python script to take a list of service tags and output the system info as a csv file in the format “tag, shipdate, SysType, Ram, HDD, Support”.

E.g.

"4GXCB1H","2008-03-29","Latitude D430","2GB","80GB","3Y NBD INTERNATIONAL (NEXT BUSINESS DAY);UPG TO 4Y NBD INTERNATIONAL (NEXT BUSINE"

Read More

Site revamp

With the change of the year I have decided to give the site a complete make over.

As I get time I’ll repopulate the old data.

I haven’t decided if I’ll bring the wiki back or not yet, if there is demand I will bring it back but if not I think I’ll just keep the site as simple as possible. Also due to the revamp my email address for this site is out of action for a while (I was getting a lot of spam in it anyhow), until I get a chance to fix it so post here and I’ll get back to you.

Please be patient as I have just moved house and have no internet, so I am having to do the site updates on my lunch hour.
Sorry to those that took the time to register, you’ll need to re-register as I am taking this chance to clear out the hundreds of spam accounts. Read More