Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] multisearch with multiple results per server #1253

Open
g-sloth opened this issue Sep 16, 2021 · 1 comment
Open

[FEATURE] multisearch with multiple results per server #1253

g-sloth opened this issue Sep 16, 2021 · 1 comment

Comments

@g-sloth
Copy link

g-sloth commented Sep 16, 2021

Hey guys!

First of all - very nice software that exactly fits my needs.

I just have one problem with the multisearch feature:

If I go to "Inventory > Search with various criteria" and search for
"All Software : Publisher" different "Microsoft" I only get 1 result per Server.

What I'd like to see is every Software that meets this criteria together with the hostname.
To illustrate what I'd like to achieve I build an SQL Query that does that (for simplicity i only selected 3 Columns):

SELECT sn.NAME AS Softwarename, h.NAME AS Hostname, sp.PUBLISHER AS Publisher

FROM software s

LEFT JOIN software_name sn

ON s.NAME_ID = sn.ID

LEFT JOIN software_publisher sp

ON s.PUBLISHER_ID = sp.ID

LEFT JOIN hardware h

ON s.HARDWARE_ID = h.ID

WHERE

sp.PUBLISHER NOT LIKE "Microsoft%";

Is this possible to get with the Webinterface?

Greetings

@TonyCollett
Copy link

Agreed! I'm looking to find which monitors are connected to which computers and I can only see one monitor on each device through "Inventory > Search with various criteria", even though most of our machines have 2 or 3 monitors connected. This seems like a large oversight

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants