Jump to content
skyper

Location Network Audit - how to combine two Dataviews

Recommended Posts

hi guys,

i need a starting point, working with v12 and no experience in creating a dataview. Two dataviews are existing: Asset/Agents and Asset/Devices, how can i combine them to a single one?

i need a small dataview with:
Client,Location,Computer Name,Agent IP Address + Client,Location,Device Name,Device IP Address

(a simple question for darren at first coffee in the morning 😉  - i have seen your great computer audit dataviews)

thanks !
 

Share this post


Link to post
Share on other sites

What is the relationship between devices and computers? Or did you want the "Device" to be either an agent or a device?

What about just exporting the two datasets into Excel and merging as desired? Unless you need to produce this regularly it is usually simpler to use Excel to get what you want.

Share this post


Link to post
Share on other sites

The relationship would be the location.  we want to see all network devices with an ip.

Merging is what we do now, but it is needed regularly - i hoped it could be "easy" done.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×