Showing results for 
Search instead for 
Did you mean: 
Level 7

Custom XLM query or View to add more filter options not available in the Query Builder (Users on Hosts >=2)

So I have a requirement to show a dashboard query where a user is logged onto more than one host at a time.  Got the query buildt to so every user and what hosts they are logged into, but I'm having trouble on how to get the query to only show where the results at 2 or more hosts.

I see two options:

1- manually modify the XLM and then import it back into the ePO

2-create a custom view and then write the XLM to call that view and import the XLM into the epo

All I need is a "where count (users) =>2  but stumped on the best way to do it.  I need to change out the Where in the example below, but stumped.

anyone know of a good XLM to SQL translator?

SQL is easy, but epo doen'st execp  SLQ

select count(*) as 'count', [EPOComputerProperties].[UserName], [EPOComputerProperties].[ComputerName], [EPOComputerProperties].[UserName], [EPOComputerProperties].[ComputerName] from [EPOLeafNode] left join [EPOComputerProperties] on [EPOLeafNode].[AutoID] = [EPOComputerProperties].[ParentID] where ( [EPOComputerProperties].[UserName] is null or ( [EPOComputerProperties].[UserName] <> N'g' )) group by [EPOComputerProperties].[UserName], [EPOComputerProperties].[ComputerName] order by [EPOComputerProperties].[UserName] asc, [EPOComputerProperties].[ComputerName] asc


<?xml version="1.0"?>

-<list id="1">

-<query id="2">

<dictionary id="3"/>

<name>Logged in Users</name>

<description>show the logged in users by computer. MAG 231914JAN15</description>







0 Kudos