SCCM Warranty Reporting

Ryan General, SCCM SMS, Sys Admin, Windows

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″]

8 thoughts to “SCCM Warranty Reporting”

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

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

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

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

  7. Just rolled this out and my boss loves it. Thank you for making me look good :)

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA

*

This blog is kept spam free by WP-SpamFree.