Results 1 to 3 of 3
Thread: query nodes with no schedule?
-
05-25-2011, 09:41 AM #1Senior Member
- Join Date
- Sep 2006
- Location
- North Dakota
- Posts
- 382
- Thanks
- 1
- Thanked 5 Times in 5 Posts
query nodes with no schedule?
It must be a Monday morning... does anyone have a way to query all nodes and list node with no schedule associated with them?
Thanks
-
05-25-2011, 09:46 AM #2Member
- Join Date
- Feb 2011
- Posts
- 300
- Thanks
- 14
- Thanked 0 Times in 0 Posts
Hi,
The following query will do the trick.
select node_name from nodes where node_name NOT IN (select node_name from associations)
-
05-25-2011, 09:48 AM #3Senior Member
- Join Date
- Sep 2006
- Location
- North Dakota
- Posts
- 382
- Thanks
- 1
- Thanked 5 Times in 5 Posts
Thanks! That worked.
Reply With QuoteSimilar Threads
-
query filespace for nodes understanding
By toddz2000 in forum Backup / Archive DiscussionReplies: 4Last Post: 03-02-2010, 10:17 AM -
A query that displays nodes and its associated volumes and last write.
By mnagie in forum TSM Reporting & MonitoringReplies: 2Last Post: 08-09-2006, 02:07 PM -
Occupancy by all nodes in one query.
By zeke in forum Performance TuningReplies: 6Last Post: 07-07-2006, 03:06 AM -
How do I query Nodes that are not associated with a client schedule?
By thekid241 in forum TSM Reporting & MonitoringReplies: 2Last Post: 05-23-2006, 01:30 PM -
IP query for all nodes connected
By rsnyder in forum TSM Reporting & MonitoringReplies: 2Last Post: 03-10-2003, 05:31 PM
