IIRC I got these on “myitforum” but I can’t remember where abouts.
I have modified them a bit to restrict to just the machines I have (mainly a Dell shop) and to exclude VMs.
For the Specific Machine report don’t forget to add the prompt variable. “Properties -> Edit SQL -> Prompts -> “New Variable”
- Name: “variable”
- Prompt Text: “Computer Name”
- Provide SQL Statement:
begin if (@__filterwildcard = '') SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0 else SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Netbios_Name0 like @__filterwildcard ORDER By SYS.Netbios_Name0 end
- [download id=”6″]
- [download id=”7″]
New URL that works for IBM/Lenovo
http://support.lenovo.com/templatedata/Web%20Content/JSP/warrantyLookup.jsp?sysMachType=*MachineType*&sysSerial=*Serial*
Great report, but seems like IBM/LENOVO warranty lookup ain´t working anymore that way since they changed the way you can inject system type and serial number
Chad,
First of all, sorry for the delay in response, I have been studying for my CCNA so haven’t had time to post.
This isn’t a script this is a report in sccm. What you could do is look at the other warranty posts. I have thought about what you have suggested, and yes it is possible to do in vbs. I just have not had time to sit down and do it.
What I would do is;
Loop through sccm and grab all the service tags you can (or run a report dump to csv).
Using vbs (or any scripting language) loop through the csv file pulling hostname and tag.
Use http libraries to connect to the dell site with the service tag.
Parse the html pulling the details and dump them to a csv.
Most of the code for this is on the site you just need to put it together.
We are also a dell shop. I’d love to use this script for looking up service tags after I pull my SCCM reports.
I’m having issues getting this to work. Instead of having it use a prompt value, could this pull from a .csv file and then return the results in a .csv?
Awesome works exactly as advertised. This will make management freak and make them glow in the dark…making them easier to hide from always a good thing!
no problem. glad the info was useful.
Just rolled this out and my boss loves it. Thank you for making me look good :)
Great! i will give this a shot. Thank you for following up.