Skip to main content

 

Uses specific Credentials

3 months ago
OfflinePaul Byers
Paul Byers
Description:  Just change the word Credential in the last line to equal the displayname of the credentials in WUG
Language: SQL
Code:
 SELECT DISTINCT dbo.Device.nDeviceID
FROM         dbo.Device LEFT OUTER JOIN
                      dbo.PivotCredentialTypeToDevice ON dbo.PivotCredentialTypeToDevice.nDeviceID = dbo.Device.nDeviceID LEFT OUTER JOIN
                      dbo.CredentialType ON dbo.CredentialType.nCredentialTypeID = dbo.PivotCredentialTypeToDevice.nCredentialTypeID
WHERE     (dbo.Device.bRemoved = 0) AND (dbo.CredentialType.sDisplayName = N'Credential')
-----
You liked this too2 people like this discussion.
 
2 members are following updates on this item.
Concluded

0 Conclusions:

1 Reply

OfflineWhatsUp Guru (Jason Williams) WhatsUp Guru (Jason Williams) said 3 months ago

Simple, yet extremely useful.  I like it.  Great addition to the library Paul.  Your badge and points have been awarded.

Would you like to comment?

You must be a member. Sign In if you are already a member.

  • 165 views
  • $obj.VersionIndex versions
  • 1 reply
  • 2 followers
     
    2 members are following updates on this item.
Post Date:
February 8, 2012
Posted By:
Paul Byers

About this forum

  • 15,220 views
  • 40 topics
  • 4 followers
     
    4 members are following updates on this item.
Viewed 165 times