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 Facebook5Tweet 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>

2 × two =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Please refer to our Error Message Reference.