MOF Editing for Hardware 2a Report

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:

MOF Editing for Hardware 2a Report

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 >> MOF Editing for Hardware 2a Report

Page: [1]

Message

<< Older Topic Newer Topic >>

MOF Editing for Hardware 2a Report - 6/11/2008 11:31:09 AM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

Hello all,

I'm about to edit our def.mof file so that the hardware 2a report (part of the SP3 upgrade) is populated correctly - I was hoping that someone could confirm the part I need to change so that the "CPU Manufactured" date is collected from our clients and reported to the server.

Thanks so much for help with this

Mos

Post #: 1

RE: MOF Editing for Hardware 2a Report - 6/11/2008 2:07:25 PM

jnelson993

Posts: 724
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

I'm not familiar with the mof needing to be edited for the 2a report...what's prompting you to do this? (I'm not saying it doesn't need to be done, I'm just saying this is news to me)

Now, the Add/Remove Programs thing is an absolute must after SP3
http://support.microsoft.com/kb/939872

_____________________________

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

(in reply to mosquat)

Post #: 2

RE: MOF Editing for Hardware 2a Report - 6/11/2008 2:44:41 PM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

Hello John,

When I ran this report I only have information for 2 years (2003 to 2005) so I presumed that something changed in my SMS_Def.mof - also I read this:

http://blogs.technet.com/smsandmom/archive/2007/11/01/asset-intelligence-reports-don-t-contain-data.aspx

which lead me to believe that I needed to change a class from "false" to "true"

Perhaps there's no information from 2005 displayed in my "Estimated Computer Age by Ranges within a Collection" report for another reason...?

Thanks v.much

Carl

(in reply to jnelson993)

Post #: 3

RE: MOF Editing for Hardware 2a Report - 6/11/2008 2:53:18 PM

jnelson993

Posts: 724
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Oh, I get ya. I thought you meant there was some edit for JUST that report. Yeah, that link is right. The classes aren't on by default and if you want all that wonderful asset intelligence data coming in you'll need to turn those classes on. Just don't forget the fix I mentioned.

_____________________________

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

(in reply to mosquat)

Post #: 4

RE: MOF Editing for Hardware 2a Report - 6/11/2008 3:38:42 PM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

Thanks for confirming this John - just wondered if you could give me some guidance on what exactly I should change as this is my first go :-)

I reckon I should be looking at the
"SMS_Processor" class in the MOF file - and should change this entry:

[SMS_Report (FALSE)     ]
       datetime   InstallDate;

To:

[SMS_Report (TRUE)     ]
       datetime   InstallDate;

Obviously there is no need for a disclaimer from you if you concur!

Cheers

Carl

(in reply to jnelson993)

Post #: 5

RE: MOF Editing for Hardware 2a Report - 6/11/2008 4:09:06 PM

jnelson993

Posts: 724
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Sherry does a much better job of esplaining than I would
http://myitforum.com/cs2/blogs/skissinger/archive/2007/05/01/sms-2003-sp3-upgrade-and-custom-mof-classes.aspx

_____________________________

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

(in reply to mosquat)

Post #: 6

RE: MOF Editing for Hardware 2a Report - 6/11/2008 4:10:33 PM

jnelson993

Posts: 724
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

http://www.myitforum.com/articles/8/view.asp?id=9543

_____________________________

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

(in reply to jnelson993)

Post #: 7

RE: MOF Editing for Hardware 2a Report - 6/11/2008 4:35:09 PM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

thanks John - and thanks to Sherry for the posts you link to

(in reply to jnelson993)

Post #: 8

RE: MOF Editing for Hardware 2a Report - 6/12/2008 8:36:10 AM

Tom_Watson

Posts: 92
Score: 4
Joined: 9/13/2006
Status: offline

BTW. Carl, I don't believe that the estimated CPU age is determined by pulling it out of WMI. If you look deeper into the report, its comparing v_GS_PROCESSOR.CPUHash0 (which comes for a clients WMI) with v_LU_CPU.CPUHash (which is part of the Asset Intelligence Knowledge Base). The v_LU_CPU view is basically a built-in list of various CPU hashes, and the information that is published against them.

If you do a quick SQL query:-

quote:

select * FROM dbo.v_LU_CPU

It'll give you the contents of the AI KB for CPU information which includes matching estimated manufacture time to the CPU hash. But its a relatively small list. Where I'm at, we use mostly HP desktop/laptops, and I would estimate that only about 25% of the PCs can have their age determined from the CPU information.

Tom

(in reply to mosquat)

Post #: 9

RE: MOF Editing for Hardware 2a Report - 6/12/2008 3:24:12 PM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

Tom,

Thanks that's great information

So what you're basically saying is that the word "estimated" in the report title is used for a good reason...the "birth date" (as it appears to be called in the report detail) is calculated by using WMI to query the CPU hash which is then compared to a list (in the AI KB) of known CPU hashes and their manufacture date...?

This is great to know but my boss wont be pleased! :-\

So back to the edit I actually made to my MOF file today (see my forth reply in this thread) to collect information regarding the processor install date - will this allow me to build a query that can pull out all systems with a CPU installation of date X so that we can determine which systems should be replaced as part of our roll out plans based on their age??

This may encourage others to describe what they do to determine the age of their workstations using SMS...hopefully!

Thanks again

Carl

(in reply to Tom_Watson)

Post #: 10

RE: MOF Editing for Hardware 2a Report - 6/12/2008 3:45:49 PM

jnelson993

Posts: 724
Score: 89
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Don't you figure the age of your workstation based on when you bought them? Like tied to an asset tracking DB...

_____________________________

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

(in reply to mosquat)

Post #: 11

RE: MOF Editing for Hardware 2a Report - 6/12/2008 4:43:48 PM

Tom_Watson

Posts: 92
Score: 4
Joined: 9/13/2006
Status: offline

Do a search for "Warranty" right here on myitforum.com. Looks like a few solutions are suggested. A few point to :-

http://www.sccmexpert.com/Products/EAM.aspx
or their partner
http://www.enhansoft.com/ (Warranty Information Reporting - WIR)

It may depend on what the end goal is. Is it to find out warranty information, or plan upgrades etc.?

Tom

(in reply to jnelson993)

Post #: 12

RE: MOF Editing for Hardware 2a Report - 6/12/2008 5:21:14 PM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

John - yeah that's what we should've done and should be doing! (sigh!)

Thanks for the links Tom - I think my boss needs the info yesterday though and we're not the quickest when it comes to software purchases....she basically has to find out which PCs are 3 or 4 years old to work out how many PCs to replace - the same thing will happen next year too so if I can get something easy to repeat it could save her a pile of work...

BW

Carl

(in reply to Tom_Watson)

Post #: 13

RE: MOF Editing for Hardware 2a Report - 6/13/2008 4:35:23 AM

Tom_Watson

Posts: 92
Score: 4
Joined: 9/13/2006
Status: offline

This got me playing around a bit last night (TV was boring)...

I took a look at Garth Jones article on this subject at http://www.myitforum.com/articles/19/view.asp?id=7374 . This was written a while back, and is really for SMS 2.0. But I thought I'd do a report for SMS 2003, that combines AI info, with links to warranty info on HP, Dell, and IBMs' websites:-

quote:

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",
             "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/MySystems/DetailsEntry.aspx?SvcTag=' + 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_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 = @Name

The @Name variable is obviously just a computer name. Some things I noted on the functionality of this:-

1. The CASE list for "v_gs_computer_system.manufacturer0 LIKE" is by no means exhaustive.
2. We're mostly an HP shop, so most of the tests I could do were based on HP systems. Plus, you're supposed to supply the country of purchase, but for those that I tested, it didn't seem to matter what country you put in, it still came back with the same dates. So I just stuck with country=US in the URL.
3. You have to register to get into the Dell page. Plus it didn't seem to be working too well last night, so I didn't get much testing done on that.
4. Some of the Dell's I saw had 2 serial numbers. I wondered if this was possibly for laptops (e.g. one serial number for the laptop, and another for the docking station). For ones like this, the serial number that seems to work is 7 characters long.
5. For IBMs, it didn't look like the serial number was populated in the system enclosure section. However, the PC BIOS section did seem to have a serial number for the PC, that did seem to be able to be referenced. Plus to get the warranty info for IBM, you need the 4 digit model number. Sometimes there's more than 4 digits, so we just take the first 4.
6. This report was for a particular system. I guess you could just make it for all systems by taking out the WHERE clause on the bottom line (untested).

Give it a whirl...

Tom

< Message edited by Tom_Watson -- 6/13/2008 5:05:10 AM >

(in reply to mosquat)

Post #: 14

RE: MOF Editing for Hardware 2a Report - 6/13/2008 5:21:53 AM

Tom_Watson

Posts: 92
Score: 4
Joined: 9/13/2006
Status: offline

In fact, for the systems with 2 serial numbers, it was ones with a docking station. So, I've amended the report like so:-

quote:

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",
               "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/MySystems/DetailsEntry.aspx?SvcTag=' + 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_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 = @Name
      AND v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 <> 12

i.e. added last line to filter out Chassis Type 12 (12 is Docking Station).

Tom

(in reply to Tom_Watson)

Post #: 15

RE: MOF Editing for Hardware 2a Report - 6/13/2008 5:27:15 AM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

Hello Tom,

That is really helpful and unexpected - I'll try this out and feedback to you but whatever the outcome thanks so much for your effort.

(in reply to Tom_Watson)

Post #: 16

RE: MOF Editing for Hardware 2a Report - 6/13/2008 6:59:37 AM

mosquat

Posts: 32
Score: 0
Joined: 5/8/2007
Status: offline

works brillliantly for me - although my boss isnt so sure....I'm convinced this is the only way to gather information regarding workstation age accurately though.

Cheers

Carl

(in reply to mosquat)

Post #: 17