Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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 https://www-secure.symantec.com/connect/sites/defa...); padding-right: 27px; margin-right: 3px; font-weight: bold; line-height: 15px; color: rgb(114, 168, 38); text-decoration: none; font-size: 12px; display: inline !important; background-position: 100% -60px; background-repeat: no-repeat no-repeat;">HighTower post in below thread,

https://www-secure.symantec.com/connect/forums/queryreport-show-what-site-pc-belongs

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."