- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
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 .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

##
Re: Automation of daily population statistics

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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