Open-AudIT

What's on your network?
It is currently Mon Jan 22, 2018 10:13 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 9 posts ] 
Author Message
PostPosted: Tue Oct 11, 2011 3:04 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1935
Location: Brisbane, Australia
I've just tested and have working code to automagically retrieve the warranty details for Dell systems.

This code does NOT screen scrape the Dell site - so it won't break if they alter their HTML. I was going to release beta4, but I think I'll hold off just a bit so I can squeeze this in.

When a system is submitted for processing, OAv2 will check if it's a Dell and if it has any warranty details already retrieved. If the answers are Yes and No - out it goes and grabs them.

There will be a couple of "config" variables needed if you are behind a proxy (such as I am at the moment) for credentials, etc.

The time to retrieve the information from Dell takes my system (here at work) about 2.5 seconds. Not an unreasonable amount and only required once per system, not every time a system is audited.

I need a schema change because there are multiple warranties per system. A simple couple of columns in the system table will not suffice. Yes an upgrade script will be provided as before.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Wed Oct 12, 2011 1:29 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1226
Great, we can definitely use that here. Don't forget warranties can be extended (for us people who like to run their systems into the ground before upgrading).


Top
 Profile  
Reply with quote  
PostPosted: Wed Nov 02, 2011 2:28 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
Would this be able to auto fill in the purchase date too? Because that would be sweet.

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Sat Mar 31, 2012 7:10 am 
Offline
Helper

Joined: Wed Apr 07, 2010 8:04 am
Posts: 99
Location: Boston, MA
Hi Mark,
I poked around OAv2(Beta5) and couldn't find how to automagically retrieve the Dell Warranty dates, recently Dell changed their support site and the warranty retrieval of OAv1 does not work anymore.
Any help would be great,
Thanks

_________________
OA v1.5.2 on Windows Server 2003 and WAMP 2.0 (Apache 2.2.22, PHP 5.4.3, MySQL 5.1.36).
OA v1.5.3 on Linux
Auditing 500 Windows 7 computers via GPO, 200 Apple OSX 10.8/10.9/10.10


Top
 Profile  
Reply with quote  
PostPosted: Sat Mar 31, 2012 7:47 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1935
Location: Brisbane, Australia
I have been playing with the code - but it seems the Dell site is not reliable.

I can get the details one minute, then the next it returns a HTTP error. Same request. Next minute it will work again. Very weird. Not sure if I want to put that in as I think it would cause more problems than it solves.

More though needed. I will post the script to do it here and others can play about with it.

I quite often get the below error.

Code:
Fatal error: Uncaught SoapFault exception: [HTTP] Could not connect to host in /var/www/warranty.php:7 Stack trace: #0 [internal function]: SoapClient->__doRequest('__call('GetAssetInforma...', Array) #2 /var/www/warranty.php(7): SoapClient->GetAssetInformation(Array) #3 {main} thrown in /var/www/warranty.php on line 7


Rename the attached file to warranty.php and place it in your web directory. Then call it through the browser...


Attachments:
warranty.txt [1.82 KiB]
Downloaded 132 times

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.
Top
 Profile  
Reply with quote  
PostPosted: Thu Apr 05, 2012 3:57 am 
I've been using a screen scraper script for a couple of years, but noticed last week that Dell have changed the web page, so I've had to recode it, I thought this Dell SOAP URL was the answer but it doesn't return the the field we need, namely ServiceLevelCode.
Dell have several warranty entitlements, and the can all end at different time, as an example the next business day may run until 2014, but the accidental damage until 2013. The web page lists all these, but since the SOAP site doesn't list the ServiceLevelCode I can't tell which is which.Presumably they have provided this in the past, as the previous code sample decodes this field.
I've tried it on several tag numbers, but never get back ServiceLevelCode or ServiceLevelDescription, only the dates and EntitlementType, (active, expired)

Oh well, I'll keep on using the screen scraper on the web page.


Top
  
Reply with quote  
PostPosted: Thu Apr 05, 2012 4:11 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1226
This is what I get for one of our 2950s that's still under warranty.

Code:
SystemShipDate: 2008-08-06<br />
Unknown expires on 2013-08-06 00:00:00<br />
Unknown expires on 2013-08-06 00:00:00<br />
Expired on 2<br />
Expired on 2<br />
Expired on 2<br />
Duration: 1.187381029129 seconds<br />
<pre>
stdClass Object
(
    [GetAssetInformationResult] => stdClass Object
        (
            [Asset] => stdClass Object
                (
                    [AssetHeaderData] => stdClass Object
                        (
                            [ServiceTag] => XXXXXXX
                            [SystemID] => PWE_2950
                            [Buid] => 11
                            [Region] => Americas
                            [SystemType] => PowerEdge
                            [SystemModel] => 2950
                            [SystemShipDate] => 2008-08-06T00:00:00-05:00
                        )

                    [Entitlements] => stdClass Object
                        (
                            [EntitlementData] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => QLX
                                            [StartDate] => 2011-08-06T00:00:00
                                            [EndDate] => 2013-08-06T00:00:00
                                            [DaysLeft] => 489
                                            [EntitlementType] => Active
                                        )

                                    [1] => stdClass Object
                                        (
                                            [ServiceLevelCode] => SV
                                            [ServiceLevelDescription] => P, Silver or ProSupport
                                            [Provider] => DELL
                                            [StartDate] => 2011-08-06T00:00:00
                                            [EndDate] => 2013-08-06T00:00:00
                                            [DaysLeft] => 489
                                            [EntitlementType] => Active
                                        )

                                    [2] => stdClass Object
                                        (
                                            [ServiceLevelCode] => SV
                                            [ServiceLevelDescription] => P, Silver or ProSupport
                                            [Provider] => DELL
                                            [StartDate] => 2008-08-06T00:00:00
                                            [EndDate] => 2011-08-06T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                    [3] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2009-08-07T00:00:00
                                            [EndDate] => 2011-08-06T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                    [4] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2008-08-06T00:00:00
                                            [EndDate] => 2009-08-06T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                )

                        )

                )

        )

)
</pre>


And a 745 that's not.
Code:
SystemShipDate: 2007-07-20<br />
Expired on 2<br />
Expired on 2<br />
Expired on 2<br />
Duration: 4.0064179897308 seconds<br />
<pre>
stdClass Object
(
    [GetAssetInformationResult] => stdClass Object
        (
            [Asset] => stdClass Object
                (
                    [AssetHeaderData] => stdClass Object
                        (
                            [ServiceTag] => XXXXXXX
                            [SystemID] => PLX_PNT_P4_745
                            [Buid] => 11
                            [Region] => Americas
                            [SystemType] => OptiPlex
                            [SystemModel] => 745
                            [SystemShipDate] => 2007-07-20T00:00:00-05:00
                        )

                    [Entitlements] => stdClass Object
                        (
                            [EntitlementData] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => QLX
                                            [StartDate] => 2008-07-19T00:00:00
                                            [EndDate] => 2010-07-19T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                    [1] => stdClass Object
                                        (
                                            [ServiceLevelCode] => NQ
                                            [ServiceLevelDescription] => Internal Use Only*Legacy SMB OL prior to 11/1/2008
                                            [Provider] => DELL
                                            [StartDate] => 2008-01-01T00:00:00
                                            [EndDate] => 2010-07-19T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                    [2] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => QLX
                                            [StartDate] => 2007-07-20T00:00:00
                                            [EndDate] => 2008-07-19T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                )

                        )

                )

        )

)
</pre>


Top
 Profile  
Reply with quote  
PostPosted: Tue Apr 17, 2012 11:53 pm 
Offline
Helper

Joined: Wed Apr 07, 2010 8:04 am
Posts: 99
Location: Boston, MA
I've ran the script a few times over and over and didn't have any problems.
Here's what I have for a Optiplex 960

Code:
SystemShipDate: 2010-05-11
 Unknown expires on 2013-05-11 00:00:00
 Expired on 2
 Duration: 1.0206830501556 seconds
stdClass Object
(
    [GetAssetInformationResult] => stdClass Object
        (
            [Asset] => stdClass Object
                (
                    [AssetHeaderData] => stdClass Object
                        (
                            [ServiceTag] => XXXXXX
                            [SystemID] => PLX_960
                            [Buid] => 11
                            [Region] => Americas
                            [SystemType] => OptiPlex
                            [SystemModel] => 960
                            [SystemShipDate] => 2010-05-11T00:00:00-05:00
                        )

                    [Entitlements] => stdClass Object
                        (
                            [EntitlementData] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2011-05-12T00:00:00
                                            [EndDate] => 2013-05-11T00:00:00
                                            [DaysLeft] => 389
                                            [EntitlementType] => Active
                                        )

                                    [1] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2010-05-11T00:00:00
                                            [EndDate] => 2011-05-11T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                )

                        )

                )

        )

)


And for 745
Code:
SystemShipDate: 2007-07-31
 Expired on 2
 Expired on 2
 Duration: 0.88607788085938 seconds
stdClass Object
(
    [GetAssetInformationResult] => stdClass Object
        (
            [Asset] => stdClass Object
                (
                    [AssetHeaderData] => stdClass Object
                        (
                            [ServiceTag] => XXXXXXX
                            [SystemID] => PLX_PNT_P4_745
                            [Buid] => 11
                            [Region] => Americas
                            [SystemType] => OptiPlex
                            [SystemModel] => 745
                            [SystemShipDate] => 2007-07-31T00:00:00-05:00
                        )

                    [Entitlements] => stdClass Object
                        (
                            [EntitlementData] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2008-07-30T00:00:00
                                            [EndDate] => 2010-07-30T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                    [1] => stdClass Object
                                        (
                                            [ServiceLevelCode] => ND
                                            [ServiceLevelDescription] => C, NBD ONSITE
                                            [Provider] => UNY
                                            [StartDate] => 2007-07-31T00:00:00
                                            [EndDate] => 2008-07-30T00:00:00
                                            [DaysLeft] => 0
                                            [EntitlementType] => Expired
                                        )

                                )

                        )

                )

        )

)

_________________
OA v1.5.2 on Windows Server 2003 and WAMP 2.0 (Apache 2.2.22, PHP 5.4.3, MySQL 5.1.36).
OA v1.5.3 on Linux
Auditing 500 Windows 7 computers via GPO, 200 Apple OSX 10.8/10.9/10.10


Top
 Profile  
Reply with quote  
PostPosted: Wed Apr 18, 2012 1:11 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1226
So if you're not playing for Team America then you don't get the full information or something like that.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group