Absent Member.. Absent Member..
Absent Member..
383 views

Automation of daily population statistics

Jump to solution

 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

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Automation of daily population statistics

Jump to solution

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);

View solution in original post

0 Likes
3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Automation of daily population statistics

Jump to solution

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 .

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Automation of daily population statistics

Jump to solution

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

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Automation of daily population statistics

Jump to solution

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);

View solution in original post

0 Likes
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.