Share

Read next article:

"All assigned Active Monitors"

Read previous article:

"Discover devices when Ping is not available"

Devices added on certain period of time

In Default | 0 comments

We will use device notes added during discovery to know the exact time of adding this device to WUG.

SELECT Temp.nDeviceID,
       Temp.sNote
FROM (
SELECT nDeviceID,
       CAST(REPLACE(REPLACE(CAST(sNote AS NVARCHAR(MAX)),'This device was scanned by discovery on',
       ''),'.','') AS datetime) AS sNote
FROM Device
) AS Temp

WHERE Temp.sNote BETWEEN '6/1/2015' AND '6/21/2015'

 

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

sixteen + 18 =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook. To submit this 'Page Public Content Access' feature for review please read our documentation on reviewable features: https://developers.facebook.com/docs/apps/review.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.