Absent Member..
383 views

## Automation of daily population statistics

Good Day

The table, CCM_DISCOVERY_STATS, contains a column called DISCOVERY_Time. Can anyone perhaps advise how this value is calculated? We need to use this table to do daily compares (Automated) of what was sent for population as opposed to what was actually populated. The table contains the values we're interested in, but we're unable to tie it to a day or time.

Any alternative suggestion to obtain the same goal would be welcomed.

Regards

Simon

1 Solution

Accepted Solutions
Highlighted
Absent Member..

## Re: Automation of daily population statistics

I think the HP time works as follows:

• Take the HP value on the table and divide it by 1000
• The result above would then represent the amount of seconds since 22:00 on 31 December 1969.

A C# function to convert this date is as follows:

int t = 1354517319; // value of time_t

System.DateTime dt = new System.DateTime(1969, 12, 31, 22, 0, 0).AddSeconds(t);

3 Replies
Highlighted
Micro Focus Expert

## Re: Automation of daily population statistics

This is the discovery time when the last discovery has run for specific job, this is represented by the job_id.

This is exactly resemeble the discovery statstics page of the UI .

Highlighted
Absent Member..

## Re: Automation of daily population statistics

Thanks for the response. Can one convert this to a format such as 08 Nov 2012?

Highlighted
Absent Member..

## Re: Automation of daily population statistics

I think the HP time works as follows:

• Take the HP value on the table and divide it by 1000
• The result above would then represent the amount of seconds since 22:00 on 31 December 1969.

A C# function to convert this date is as follows:

int t = 1354517319; // value of time_t

System.DateTime dt = new System.DateTime(1969, 12, 31, 22, 0, 0).AddSeconds(t);

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.