IT Management Suite

I run reports in altiris that show the location of a device by vlan but the issue I run into is our wireless network is the same vlan across mutiple locations so they end up in a catch all location called wireless

 

Now I can run powershells against our AD and pull devices and OS's by OU but it lacks some of the info I can get in the altiris reports, is there a simple report that I can pull from altiris that will show the devices OU location that I'm not see or had someone created one like that?

Hi Cody,

Very basic, but this should get you what you are looking for.  Obviously, more can be added as necessary.  Simply create a new SQL report and add this query to it.

select vc.Name,
vc.[OS Name],
vc.[IP Address],
vc.[MAC Address],
oum.[Distinguished Name] as 'AD OU'
from Inv_OU_Membership oum
join vcomputer vc on vc.Guid = oum._ResourceGuid
where IsDirectMember = 1
and vc.IsManaged = 1

This seemed to work but only half way, we have over 11k devices but it only grabs 5k and some are doubles, guessing something is wrong on my end I did also find a bunch of AD reports built in under the NS report section but they all time out when trying to run them

It could be that the computer doesn't have an OU, with the JOIN and IsDirectMember = 1

Or it isn't managed anymore,

You could switch the first Table to be vComputer and LEFT JOIN on Inv_OU_Membership but then the WHERE would still filter it.

Try to do a

select * from inv_ou_membership

where isdirectmember=1

 

what is your count?

 

Well you learn something new everyday, our importing of AD into altiris was no longer running. Fixed that so now I was able to add the OU Membership to the query and we have a report that shows devices by OU now

Hi Cody, If this is solved, please mark solution and the post as solved.

Thanks!