Report on age of desktop/laptop hardware

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Report on age of desktop/laptop hardware

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Report on age of desktop/laptop hardware

Page: [1]

Message

<< Older Topic Newer Topic >>

Report on age of desktop/laptop hardware - 9/24/2008 8:44:39 AM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

Does anyone know of a way to report on the age of desktop or laptop? When the actual hardware was built? I want to be able to run reports on hardware that is 3 years old or 4 years old, etc.

Post #: 1

RE: Report on age of desktop/laptop hardware - 9/24/2008 10:34:18 AM

skissinger

Posts: 2119
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

Do you have SP3 & AI? If so, check out the hardware 02a & 02b reports.

If you don't have AI, you can also get imaged date. That may or may not be useful depending upon if a box was reimaged during it's lifecycle. Check the report "Computer operating system version history", the "Install Date" field.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to dgagliardotto)

Post #: 2

RE: Report on age of desktop/laptop hardware - 9/24/2008 10:35:54 AM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

We do have those reports. Unfortunately if a box is reimaged during its lifecyle that information won't be correct. Thanks for the quick response.

(in reply to skissinger)

Post #: 3

RE: Report on age of desktop/laptop hardware - 9/24/2008 10:56:01 AM

jnelson993

Posts: 900
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

That doesn't make sense...the reports go off the birth date of the CPU (v_LU_CPU.CPU_Birth)...not off the OS installation date...

Are you ASSUMING it would get reset, or have you witnessed it?

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to dgagliardotto)

Post #: 4

RE: Report on age of desktop/laptop hardware - 9/24/2008 11:04:18 AM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

Thanks. that appears to be more in line with what I am looking for. Although that is just CPU date, that should be realtively close to the date of the PC. about 50% of my results are showing up with (Not Available) for the estimated date of CPU manufacture. Any thoughts on this?

Thanks.

(in reply to jnelson993)

Post #: 5

RE: Report on age of desktop/laptop hardware - 9/24/2008 12:53:45 PM

skissinger

Posts: 2119
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

The cpu manufacture date is part of the AI additional information which was installed with AI. The information for that field is static--it doesn't get reported by the client. The CPU does, but the date of birth is essentially hard coded into a table in the database. So essentially there is no birth date available for that CPU type. Unfortunately, I don't believe the AI tables (like that one) are updated too frequently. You may need to do your own research to estimate the "birth date" of those CPUs.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to dgagliardotto)

Post #: 6

RE: Report on age of desktop/laptop hardware - 9/24/2008 1:00:31 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

I know how to get the warranty date using a 3rd party tool. Is that more what you are looking for?

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to dgagliardotto)

Post #: 7

RE: Report on age of desktop/laptop hardware - 9/24/2008 1:54:58 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Gjones, please Share.

(in reply to gjones)

Post #: 8

RE: Report on age of desktop/laptop hardware - 9/24/2008 1:55:16 PM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

Thank you both.

Gjones,

I definitely would be interested in the 3rd party tools.

Thanks

(in reply to gjones)

Post #: 9

RE: Report on age of desktop/laptop hardware - 9/24/2008 3:01:35 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

Let me start of by saying that I work for Enhansoft and they produce Warranty Information Reporting (WIR) which is sold through resellers such as SCCM Expert. For more information see http://www.sccmexpert.com/Products/EAM.aspx and you can download the evaluation copy there too.

If you have questions feel free to ask me offline.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to dgagliardotto)

Post #: 10

RE: Report on age of desktop/laptop hardware - 9/30/2008 5:59:19 AM 2 votes

Tom_Watson

Posts: 118
Score: 9
Joined: 9/13/2006
Status: offline

You might want to take a look at the report I posted on http://www.myitforum.com/forums/m_180656/mpage_1/key_/tm.htm#180805 (which is roughly based on an article Garth did way back in SMS 2.0 days).

Its not foolproof however, so you might want to go with the 3rd party tool Garth mentioned.

Regards,
Tom Watson

(in reply to gjones)

Post #: 11

RE: Report on age of desktop/laptop hardware - 9/30/2008 4:56:22 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Tom, thx for the posting and Link, I think Dell changed the way you post for the Warranty Info including the link to it, after changing to the proper warranty link on Dell's site, I'll have to re-enter the service tag.

I know that Dell runs the Script as a Post and not as a Get.

basicaly it will take me to this link
http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&l=en&s=gen
and then i'll have to manually enter the tag.

Can this be fixed to make it behave similarly to the one of HP?

(in reply to Tom_Watson)

Post #: 12

RE: Report on age of desktop/laptop hardware - 10/1/2008 3:36:36 AM

Tom_Watson

Posts: 118
Score: 9
Joined: 9/13/2006
Status: offline

Not really. It's really down to the way the Dell website works, which we have no control over.

I have found that if you log into the Dell website first, then with the same browser session run the report, and then click on a link for a Dell PC's warranty information, it takes you directly to the information. So if you are mostly a Dell shop, login first. We are mostly HP, so I don't have a lot of Dells to test with.

Regards,
Tom Watson

< Message edited by Tom_Watson -- 10/1/2008 3:37:32 AM >

(in reply to MeenEnta)

Post #: 13

RE: Report on age of desktop/laptop hardware - 10/1/2008 5:23:33 AM

Tom_Watson

Posts: 118
Score: 9
Joined: 9/13/2006
Status: offline

BTW. I changed the report to include Levono and Gateway PCs.

Regards,
Tom Watson

(in reply to Tom_Watson)

Post #: 14

RE: Report on age of desktop/laptop hardware - 10/1/2008 11:08:33 AM 1 votes

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Thx Tom for Adding the Lonovo / Gateway, but we were able to get the Dell links for Warranty to work, here's the code: changes in red.

SELECT DISTINCT v_r_system.netbios_name0                  AS "Computer Name",
              v_gs_system_console_usage.topconsoleuser0 AS "Top Console User",
              v_gs_system_enclosure.serialnumber0       AS "Serial Number",
              v_gs_system_enclosure.smbiosassettag0     AS "Asset Tag",
              v_GS_PC_BIOS.serialnumber0                AS "PC Bios Serial Number",
              v_gs_computer_system.manufacturer0        AS "Computer Manufacturer",
              v_gs_computer_system.model0               AS "Computer Model",
v_GS_OPERATING_SYSTEM.InstallDate0 AS "Install Date (Cloned)",
              "Estimated Date of CPU Manufacture" = CASE
                                                      WHEN (CAST(v_lu_cpu.cpu_birth AS VARCHAR) IS NULL) THEN '(Not Available)'
                                                      ELSE CAST(v_lu_cpu.cpu_birth AS VARCHAR)
                                                    END,
              ismulticore0                              AS "Is Multi Processor System",
              CASE
                WHEN v_gs_computer_system.manufacturer0 LIKE "Hewlett%" THEN 'http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + v_gs_system_enclosure.serialnumber0 + '&country=US'
                WHEN v_gs_computer_system.manufacturer0 LIKE "HP%" THEN 'http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + v_gs_system_enclosure.serialnumber0 + '&country=US'
                WHEN v_gs_computer_system.manufacturer0 LIKE "Compaq%" THEN 'http://h20000.www2.hp.com/bizsupport/TechSupport/WarrantyResults.jsp?sn=' + v_gs_system_enclosure.serialnumber0 + '&country=US'
                WHEN v_gs_computer_system.manufacturer0 LIKE "Dell%" THEN 'http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?c=us&l=en&s=gen&servicetag=' + v_gs_system_enclosure.serialnumber0
                WHEN v_gs_computer_system.manufacturer0 LIKE "IBM%" THEN 'http://www-304.ibm.com/systems/support/supportsite.wss/warranty?type=' + LEFT (v_gs_computer_system.model0, 4) + '&serial=' + v_GS_PC_BIOS.serialnumber0 + '&action=warranty&brandind=5000008'
                ELSE '(Not available)'
              END AS "Warranty Information"
FROM   v_gs_processor
     INNER JOIN v_r_system
       ON v_gs_processor.resourceid = v_r_system.resourceid
INNER JOIN v_GS_OPERATING_SYSTEM
       ON v_gs_processor.resourceid = v_GS_OPERATING_SYSTEM.resourceid
     INNER JOIN v_gs_system_enclosure
       ON v_gs_system_enclosure.resourceid = v_r_system.resourceid
     INNER JOIN v_GS_PC_BIOS
       ON v_GS_PC_BIOS.resourceid = v_r_system.resourceid
     INNER JOIN v_gs_computer_system
       ON (v_gs_computer_system.resourceid = v_r_system.resourceid)
     LEFT JOIN v_gs_system_console_usage
       ON v_gs_system_console_usage.resourceid = v_r_system.resourceid
     LEFT JOIN v_lu_cpu
       ON Lower(v_lu_cpu.cpuhash) = Lower(v_gs_processor.cpuhash0)
WHERE v_r_system.netbios_name0 like @Name
     AND v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 <> 12

(in reply to Tom_Watson)

Post #: 15

RE: Report on age of desktop/laptop hardware - 10/1/2008 11:59:36 AM

Tom_Watson

Posts: 118
Score: 9
Joined: 9/13/2006
Status: offline

Many thanks. I've updated the report over at http://www.myitforum.com/forums/m_180656/tm.htm

Regards,
Tom Watson

(in reply to MeenEnta)

Post #: 16

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:04:47 PM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

This is great stuff. Thank you both.

(in reply to Tom_Watson)

Post #: 17

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:12:23 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

The Main thx go to Tom for great work done; I just played with what he offered.

(in reply to dgagliardotto)

Post #: 18

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:16:01 PM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

Thank you Tom. This is very helpful.

Is there anyway to pull the warranty data from the vendors site and put that in the report instead of just showing the link?

Unfortunately. I wanted to use the Estimated Date of CPU Manufacturer but about 50% of our PCs show up as not available. After speaking with MSFT on this they mentioned that there is an AIS update that could fix this problem.

(in reply to MeenEnta)

Post #: 19

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:28:40 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

dgagliardotto

That is why i added one item onto Tom's script (see my posting above) and that is the Date the system was cloned
v_GS_OPERATING_SYSTEM.InstallDate0 AS "Install Date (Cloned)",

and

INNER JOIN v_GS_OPERATING_SYSTEM
ON v_gs_processor.resourceid = v_GS_OPERATING_SYSTEM.resourceid

This will give me a fair estimate to when the machine was acquired and deployed. granted that sometime we have to reclone a machine but this is a rare case, I would say we reclone 5 machines per year out 1200.

One more thing, we name our work stations like this: DYYMMXXX, which means D for Desktop (L for laptop etc..) YY = year purchased, and MM = Month purchased XXX is sequence of machine. which helps alot in warraty services.

i hope that helped.

(in reply to dgagliardotto)

Post #: 20

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:30:24 PM

Tom_Watson

Posts: 118
Score: 9
Joined: 9/13/2006
Status: offline

I guess that would be where you go with the 3rd party tool Garth mentioned above.

Tom

(in reply to dgagliardotto)

Post #: 21

RE: Report on age of desktop/laptop hardware - 10/1/2008 12:35:27 PM

dgagliardotto

Posts: 156
Score: 0
Joined: 4/6/2004
Status: offline

Thanks.