Video Screencast Help

Query for altiris

Created: 25 Jan 2014 • Updated: 03 Feb 2014 | 3 comments
This issue has been solved. See solution.

Hi support team,

In my company there are three location and it is very dificult fo find that find out to which system belongs from which location.

Does anyone have a query that will show me what altiris site a computer belongs to? 

Operating Systems:

Comments 3 CommentsJump to latest comment

Ambesh_444's picture

Hello bist17,

Can you check with below query and revert me.

 

 

SELECT [vc].[Guid],

vc.Name AS 'Computer Name',

vc2.Name AS 'Task Server Name',

vs.Name AS 'Site Name'

FROM [vComputer] AS [vc]

INNER JOIN [Inv_AeX_AC_TCPIP] AS [tcp] ON [tcp].[_ResourceGuid] = [vc].[Guid]

INNER JOIN [vSite] AS [vs] ON [vs].Name LIKE '%'

INNER JOIN [vSiteSubnetMap] AS [ss] ON [ss]._ResourceGuid = [vs].[Guid]

INNER JOIN [Inv_Subnet] AS [sn] ON [sn].[_ResourceGuid] = [ss].[SubnetGuid]

INNER JOIN [Inv_Client_Task_Resources] ctr on ctr._ResourceGuid = vc.Guid

INNER JOIN vComputer vc2 on vc2.Guid = ctr.ClientTaskServerGuid

WHERE

dbo.[fnIsIPInSubnet2]([tcp].[IP Address],[sn].[Subnet],[sn].[Subnet Mask]) = 1

 

 

 

And plz check HighTower post in below thread,

https://www-secure.symantec.com/connect/forums/que...

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

SOLUTION
Ambesh_444's picture

Hi Bisht,

Any update on this..

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."