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'

 

Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

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>

nineteen − ten =

Facebook

Unable to display Facebook posts.
Show error

Error: Error validating application. Application has been deleted.
Type: OAuthException
Code: 190
Please refer to our Error Message Reference.