Inventory

[Sid9678]

I would like to know how to setup/configure Symantec Management Console to pull the serial number and check the warranty status for Dell & HP computers? Anyone can assist or have any documentation on accomplishing this?

[--]

Hi Sid9678,

We did use the custom inventory to lookup serial numbers for HP back in 2011, that web service from HP has been secured using capcha so we can't use it as is.

Some manufacturers provide an API to do this: https://techdirect.dell.com/portal/AboutAPIs.aspx

There are some scripts already developed to assist with what you are looking for: https://gist.github.com/teroka/0720274b87b77fe7171f , that could be customized to work with custom inventory, and there are different ways for running it, from the SMP server of from each machine and then updating the inventory.

Custom inventory: https://help.symantec.com/cs/ITMS8.5/INVENTORY/v17356799_v127279685/Creating-a-custom-inventory-script-task?locale=EN_US
Popular scripts: https://knowledge.broadcom.com/external/article/178794/popular-custom-inventory-samples-7x-8x.html

Cheers,
Rufus

------------------------------
ProServe Consulting
------------------------------

[Sid9678]

thank you, I'll look into this. No API for HP computers?

[Sid9678]

Is there a way that I can run a report that would list the following?
PC Name
Logged in user
Make
Model
Serial number

[Igor Perevozchikov]

Hi Sid9678!
Actually you can easily create or own custom report to see required data, using report builder from ITMS Views page.
Open SMP Console -> Manage -> Computers -> "All Computers" org group selected, now expand tree and you will see there this button (on pic below). 
Using this dialog, you can type required column name in search field there and build your own custom report.

Here is a SQL Query from this mentioned on picture above custom report

SELECT DISTINCT
[vri1_Computer].[Guid] AS [Guid],
[vri1_Computer].[Name] AS [Name],
[dca2_AeX AC Identification].[Last Logon User] AS [Last Logon User],
[ajs6_vHWComputerSystem].[Model] AS [Model],
[ajs5_vHWBaseboard].[Serial Number] AS [Serial Number]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca2_AeX AC Identification]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Identification].[_ResourceGuid])
LEFT OUTER JOIN ([ScopeMembership] AS [ajs3_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs4_FolderBaseFolder]
ON ([ajs3_ScopeMembership].[ScopeCollectionGuid] = [ajs4_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs3_ScopeMembership].[ResourceGuid])
LEFT OUTER JOIN [vHWBaseboard] AS [ajs5_vHWBaseboard]
ON ([vri1_Computer].[Guid] = [ajs5_vHWBaseboard].[_ResourceGuid])
LEFT OUTER JOIN [vHWComputerSystem] AS [ajs6_vHWComputerSystem]
ON ([vri1_Computer].[Guid] = [ajs6_vHWComputerSystem].[_ResourceGuid])
WHERE [vri1_Computer].[Guid] IN (

SELECT computer.[Guid] FROM
(
SELECT
[vri1_Computer].[Guid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN ([ScopeMembership] AS [ajs2_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs3_FolderBaseFolder]
ON ([ajs2_ScopeMembership].[ScopeCollectionGuid] = [ajs3_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs2_ScopeMembership].[ResourceGuid])
WHERE
(
(
([ajs3_FolderBaseFolder].[ParentFolderGuid] = '91c68fcb-1822-e793-b59c-2684e99a64cd')
)
)

) AS computer
INNER JOIN fnGetTrusteeScopedResourcesByType('493435f7-3b17-4c4c-b07f-c23e7ab7781f','%TrusteeScope%',1) AS [fnGTSR_3] ON computer.[Guid] = [fnGTSR_3].[ResourceGuid]
INNER JOIN vComputer AS [vCMP_4] ON computer.[Guid] = [vCMP_4].[Guid]

)
GROUP BY
[dca2_AeX AC Identification].[Last Logon User],
[ajs5_vHWBaseboard].[Serial Number],
[ajs6_vHWComputerSystem].[Model],
[vri1_Computer].[Guid],
[vri1_Computer].[Name]
ORDER BY
[Last Logon User],
[Serial Number],
[Model]

Thanks,
IP.

------------------------------
Software QA Engineer
Broadcom Inc.
------------------------------

[Sid9678]

thank you

[Sid9678]

I followed these steps here and I was able to get Dell to work but not HP. What is the url to get this to pull up the serial number for HP: https://community.broadcom.com/groups/communities/community-home/librarydocuments/viewdocument?DocumentKey=13045b3a-be58-41c4-b38e-8b4b06b7394c&CommunityKey=36a652c6-c7e1-4701-af0f-b978f701f102&tab=librarydocuments