My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

ziembor

By: a guest | Apr 13th, 2009 | Syntax: SQL | Size: 0.17 KB | Hits: 779 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. SELECT FullName, DisplayName
  2. FROM OperationsManagerDW.dbo.vManagedEntity WITH (nolock) WHERE Path IS NULL AND FullName NOT LIKE '%:%' AND DisplayName LIKE '%Computers%'
create new paste | create new version of this paste RAW Paste Data