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.
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.
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
ASKER
hmmm, ok. What about the BIOS date?
is this information available in BIOS, I'm asking about your machines BIOS ???
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%'
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
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
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.
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
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
ASKER
How can i confirm? You stated that be default they are not enabled.
How to Enable Asset Intelligence
http://technet.microsoft.com/en-us/library/bb694072.aspx
http://technet.microsoft.com/en-us/library/bb694072.aspx
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
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
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.
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Computer with a specific Operating System
it's in Operating System Category
you will find the installation date and last boot up time