Symantec Management Platform (Notification Server)

 View Only
Back to discussions
Expand all | Collapse all

How do you select via sql a specific resource name from a resource type?

  • 1.  How do you select via sql a specific resource name from a resource type?

    Posted Jan 18, 2011 09:21 AM

    I am looking to pull the resource name from two different resource types (one called Computers and the other is a custom resource type called Applications) to beable to write a cmdb rule to update a data class type that is custom on the Computer resource.

    How do I find the resouce names in the database to beable to do the lookup on the select statement.

    to make it simple I am looking for this select statement to start off.

    Select X.resouce_name from X_table X, recourcetype Y

    where Y.Name = 'Applications'

    ANY HELP WOULD BE GREAT!

    JEAN



  • 2.  RE: How do you select via sql a specific resource name from a resource type?
    Best Answer

    Posted Jan 18, 2011 10:18 AM 
    

    SELECT vi.[Name]
FROM dbo.[vItem] vi
JOIN dbo.[vResource] vr
   ON vi.[Guid] = vr.[Guid]
JOIN dbo.[ResourceType] rt
   ON vr.[ResourceTypeGuid] = rt.[Guid]
WHERE rt.[Name] IN ('Computer' , 'Applications')
    

     
    

                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    • 
                
                    
  • 
			                                
                                
                                
    
                                    
    
                                        
    
                                            
                                            3.  
                                            RE: How do you select via sql a specific resource name from a resource type?
                                            
                                            
                                            
                                        
    
                                    
    
                                    
    
                                        
    
				
                                                
    
                                                    
    
					
        
        
        
        
        
        
        
            
        
    
				
    

                                                
    
                                            
			
    
                                    
    
                                
    
                                
                                

                                
    
                                    
    
                                        
                                    
    

                                    
    
				

                                        
    
                                            
    
                                                
    
                                                    
    
                                                        Posted Jan 18, 2011 02:35 PM
                                                        
                                                    
    
                                                
    
                                            
    
                                            
    
                                                

                                                
                                            
    
                                        
    

                                        
    
                                            
    
                                                
    THANKS!!!! SO MUCH!
    

                                                
    
					
                                                    

        
                                                
				
    
                                                
    
                                                    
                                                
    
                                                
                                            
    
                                        
    

                                        
                                        

                                    
			
    

                                    
                                
    

                                
                                
    
                                
    
                            
		
    •