Forum Discussion
Zenshai
12 years agoLevel 4
Try this (tested on OpsCenter 7.1.0.2):
select distinct p.servername, p.policyname, l.name, p.clienthostname, p.filelist, p.ScheduleName, p.ScheduleTypeName from nom_NBPolicy p, lookup_policyType l where p.policystatus = 0 and p.active = 1 and l.id = p.policyType
Related Content
- 5 months ago
- 3 months ago
- 26 days ago