| Poll |
| You like it? |
| YES |
 
|
92% |
[ 11 ] |
| NO |
|
0% |
[ 0 ] |
| don't understand this... |
|
0% |
[ 0 ] |
| have no DELL hardware |
|
8% |
[ 1 ] |
| Total Votes : 12 |
|
| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 25/07/2011 09:54:54
|
EbroIN
Elite SysAider
Joined: 25/03/2009
Messages: 244
Offline
|
Hi there,
recently I coded a little script that automatically retrieves the purchase date and warranty end date from the DELL homepage for DELL assets. Unfortunatelly I haven't found a built in method in SysAid so I did a little vbscript to do that for me.
Any comments are very welcome, any improvements as well :p
This is kind of "quick" and - due to the nature of the script - very very dirty.
This script is built for Dell assets in the EMEA region (will scrap the EMEA site for warranty dates) and might change over time if Dell changes anything on their layout. It is important that the database for SysAid is located on a German MS SQL Server.
It is kind of helpfull to have little knowledge about vbscript before using this.
HAVE A (WORKING) BACKUP BEFORE USE! USE AT YOUR OWN RISK! UNDERSTAND THE CODE IN THE SCRIPT!
I wonder if DELL (or HP, IBM, Lenovo, Acer or whatever) has no API present to get those dates out of their databases. This is kind of dirty and I am looking in the Dell homepage for a table (inside the returned HTML code) and parse only the text contents. The script will look for table cells and add "," between the values. After that the script splits the string into an array and then locates the purchase and the warranty end date. After checking inside the SysAid database, the script UPDATES its value inside the table. For "non German" installations the parsing of the Date into an international format (like '2011-07-25') is necessary - feel free to modify the script to your needs.
I've done this on my database and it worked well for my 200+ Dell computers 
Please leave feedback if you can use this, and if you've modified things, please upload your modifications. I think we can all participate from your ideas.
best regards - EbroIN
| Filename |
dell_updater.vbs |
|
| Description |
the actual vb script |
| Filesize |
10 Kbytes
|
| Downloaded: |
41 time(s) |
|
|
|
26/09/2011 16:03:58
|
jstrubberg
SysAider
Joined: 14/09/2011
Messages: 8
Offline
|
I wish I knew enough about SQL to get this to work for an american DB.
250+ pieces of equipment to do by hand.
|
|
|
26/09/2011 18:42:21
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
What and excellent script !
/BEGIN OFFICIAL DISCLAIMER/
All database modifications outside of SysAid invalidate your support
/END OFFICIAL DISCLAIMER/
Perhaps SysAid could provide their official blessing to use this script when we have finished please?
I ran it in test mode
in testing, I found I have some manual asset records for dell's that do not have an agent and were added by hand with either no serial number or duff ones! (I will get these fixed).
To stop these blowing up the script I added the following changes:-
Line 116 I added
and after the line
I added
This stops it bombing out if it cannot get a result because of a duff serial number.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
26/09/2011 19:53:11
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
testing on my sandbox, only some records get set and they get set with the incorrect american date order mm/dd/yyyy , yet if you turn on chatty it shows the sql statement it would put in was in the uk format dd.mm.yyyy ?
any ideas?
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
16/07/2012 08:35:48
|
NWG-IT
Elite SysAider
Joined: 07/01/2010
Messages: 203
Offline
|
are SysAiders still using this script?
we have a lot of Dell machines and it would be great if I can run the script to get all the warranty details filled in properly.
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
