Link to home
Start Free TrialLog in
Avatar of Xeif3r
Xeif3r

asked on

SCCM 2007 Report for PC Age

Please help!
     I am in dire need of a report that will give me the age of the PCs on our domain.  We're looking to refresh any machines older than three years.  We're using SCCM 2007.
Avatar of Abdul Jalil Abou Alzahab
Abdul Jalil Abou Alzahab
Flag of Canada image

If you have sccm 2007 go to reports and check for the following report name:
Computer with a specific Operating System
it's in Operating System Category

you will find the installation date and last boot up time
Avatar of Xeif3r
Xeif3r

ASKER

But what if the machine has been reimaged?  Will the date still be accurate?  What about going of the BIOS date?
this report will show the date when last time you install or deploy Windows
Avatar of Xeif3r

ASKER

hmmm, ok.  What about the BIOS date?
is this information available in BIOS, I'm asking about your machines BIOS ???
Avatar of Xeif3r

ASKER

Here is what I'm working with so far.  The report works except for the fact that many of the models are not "found", and thus do not report a CPU manufacture date (which is the current identifier that i'm using).  Any suggestions?
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 'Dell%' 
  THEN 'http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?servicetag=' + v_gs_system_enclosure.serialnumber0
  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 'IBM%' 
  THEN 'http://www-304.ibm.com/systems/support/supportsite.wss/warranty?type=' + LEFT(REPLACE(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_GS_SYSTEM_ENCLOSURE.ChassisTypes0 <> 12 
AND
v_gs_computer_system.manufacturer0 NOT LIKE 'VMware%'

Open in new window

Let me check and will update you...
You can try using the report Hardware 02B - Computers within an age range within a collection.  This uses the manufacture date of the cpu.
Asset Intelligence functionality is provided by several WMI classes. Each class enables a given set of reports. If any class is disabled, that data won't flow back to the site server and therefore will not be available for that report. We documented the correlation between classes and reports in the CHM file that shipped with the products, but to save time and have the information in one spot, I'll copy/paste that information into this post.

SMS_Processor

This is an existing SMS class to which new properties have been added to provide more complete data about processors. The following reports are dependent upon this class:

    Hardware 1A - Summary of Computers in a Specific Collection

    Hardware 2A - Estimated Computer Age by Ranges within a Collection

    Hardware 2B - Computers within an age range with a collection

    Hardware 8A - Hardware that is Not Ready for a Software Upgrade

    Hardware 9A - Search for computers

Please also check the following link:
http://msdn.microsoft.com/en-us/library/cc145394.aspx
Avatar of Xeif3r

ASKER

Yes, I've tried this.  Unfortunatly a lot of the models are not able to locate the CPU date for some reason.  So can....others can't; it's appears to be specific to the model number.
Avatar of Xeif3r

ASKER

How do I see which modules of AI are enabled?
Did you enable Asset Intelligence classes?

In the default configuration for Microsoft System Center Configuration Manager 2007, the Asset Intelligence classes are not enabled. Therefore, it is necessary to enable the Asset Intelligence classes that will be used
Enabling Asset Intelligence Data Collection should be enabled
Avatar of Xeif3r

ASKER

How can i confirm?  You stated that be default they are not enabled.
You may also check the following link:
Hardware Inventory Reporting Classes Required for Asset Intelligence Reports
http://technet.microsoft.com/en-us/library/cc161933.aspx

Asset Intelligence: Reports don't contain data
http://blogs.technet.com/smsandmom/archive/2007/11/01/asset-intelligence-reports-don-t-contain-data.aspx
Avatar of Xeif3r

ASKER

based on the code that i uploaded, any idea why some machines would report a CPU Manufacture date, and others wouldn't?
maybe SCCM didn't collect the required information for this machine it CPU very old and support this feature.
Avatar of Xeif3r

ASKER

Hmm....I doubt it.  One of the machines is an HP EliteBook 6930p.  This is a current model.  Is it possible that the CPU Birth date list in SCCM is incomplete?  Any way to upgrade or refresh it with current info?
I already gave you 2 reasons not one. 2nd one was sccm didn't collect all required data.

did u enable Asset Intelligence and check
Hardware Inventory Reporting Classes Required for Asset Intelligence Reports
http://technet.microsoft.com/en-us/library/cc161933.aspx

Asset Intelligence: Reports don't contain data
http://blogs.technet.com/smsandmom/archive/2007/11/01/asset-intelligence-reports-don-t-contain-data.aspx
Avatar of Xeif3r

ASKER

Ok, I've enabled all AI options.  Will it take some time for SCCM to collect all the info before I can run a report?
 
 
ASKER CERTIFIED SOLUTION
Avatar of micalkin
micalkin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial