Advertisement
Advertisement
| 06.26.2008 at 01:15PM PDT, ID: 23519748 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: |
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetWkstnsInNonSupportedOUs] @Wkstn_OU smallint, @Wkstn_OU2 smallint, @Wkstn_OU3 smallint, @Wkstn_OU4 smallint, @Wkstn_OU5 smallint AS BEGIN SELECT N.ComputerName, O.OUName FROM Devices D INNER JOIN Network N ON D.DeviceID=N.DeviceID INNER JOIN OU O ON N.OUID=O.OUID WHERE O.OUID <> @Wkstn_OU Or O.OUID <> @Wkstn_OU2 Or O.OUID <> @Wkstn_OU3 Or O.OUID <> @Wkstn_OU4 Or O.OUID <> @Wkstn_OU5 END |