ePO Web API Query: How to get the system serial number for each computer?

[Shuning]

Hi, 

Is there any way to get the computer's system serial number directly from ePO Web API query? We looked through the tables (including EPOComputerProperties table), but could not find any system serial number information listed. 

Any help would be really appreciated. 

Thanks!

[cdinet]

Are you referring to the serial number that is returned for the cpu?  If so, see KB92947.  The cpu serial number is only option in queries to pull any info on, so unless you have one of the below cpu's, that info is not available.

CPU Serial Number information can only be retrieved from a CPU, that included the Processor Serial Number (PSN). PSN is a unique, retrievable identification number that can only be read via the software CPUID instruction. 

NOTE: PSN needs to be enabled in the BIOS, for it to function.

Only the following Intel processors support the PSN feature:

• Pentium III Xeon
• Mobile Pentium III
• Pentium III processors

[Shuning]

Thanks for the reply! However, it is not the CPU serial number, it is the system's hardware serial number (for example, the serial number from Dell). We see it in the EPO UI dashboard, just don't know how to get the information from API call:

[cdinet · Accepted solution]

Ok, thanks for clarification.  I created a simple query in epo for system name and serial number - here is where it gets that info from.

select [EPOLeafNode].[NodeName], [EPOComputerProperties].[SystemSerialNumber], [EPOLeafNode].[AutoID] from [EPOLeafNode] left join [EPOComputerProperties] on [EPOLeafNode].[AutoID] = [EPOComputerProperties].[ParentID] order by [EPOLeafNode].[NodeName] asc

[cdinet]

Just as a side note, you can create queries in epo, save them, then view sql on the query to find syntax, table locations, etc, where epo pulls data from.  One thing to keep in mind, the api doesn't necessarily pull data from every table and every column in the table.  So you can try running just that simple query to see if the api will pull the desired data or not.

[Shuning]

This is helpful. We are looking at the EPOComputerProperties table too, but cannot find the SystemSerialNumber from the table schema. Do we need to request this field explicitly?

[cdinet]

Yes you do - it is a column in the epocomputerpropertiesmt table.  Now one thing to also keep in mind.  The actual table name ends in MT, but it appears the query isn't using that.  EPO 5.10 uses views more than tables, so that query syntax I copied is looking at the view rather than the table.  However, it is also a valid column in the view.  See if explicitly listing the column helps.

[Shuning]

Explicitly listing the column works! Thanks much!

But we have two ePO endpoints, the other comes with an older version and does not have the serial number column. Will the query support something like "select EPOComputerProperties.*"? Then we don't need to list two different sets of columns for those two endpoints.

[cdinet]

What agent extension version are you running on the older epo?  That available column may be related to that.  You could possibly run select * from epocomputerproperties to see if it returns that value, but if the column isn't available in the older epo, then it won't hold that data.  I am not sure when that available property was added.

[Shuning]

Thank you! We tried yesterday, looks like the web API does not support "select *" and the columns need to be explicitly listed in the select statement. We can probably adjust our codes for this.