andyinv
2 Bronze

Custom query group issue

Bit of a problem if you do a query on device name and "does not contain". It excluded the BSAB* ones, but not the bsab* ones...

 

Capture.JPG

0 Kudos
13 Replies
DELL-Pupul M
4 Tellurium

Re: Custom query group issue

Hi,

Thanks for your query. I tried creating a similar query in device tree and it worked for me seamlessly. Is there a specific page where you are seeing this problem?

This is the similar query i created:

( Device Sub-Type = iDRac ) AND ( Device Name does not contain N1 ) AND ( Device Name does not contain NL )

Thanks,
Pupul

0 Kudos
andyinv
2 Bronze

Re: Custom query group issue

Thanks Pupul for repsonse.

It happens in "Devices, All Devices". Interestingly, I have a separate query that INCLUDES only the bsab/BSAB devices, and it works fine.

I notice that you are excluding two different strings - in mine, it's the same string but only the upper/lowercase is diffferent. Perhaps that's a factor?

 

Tags (1)
0 Kudos
hoffmc5
1 Copper

Re: Custom query group issue

Might there be any feature that could create a custom query group from a CSV file?

We would love to import the manifest file we get from Dell when we receive pallets of servers.

0 Kudos
DELL-Pupul M
4 Tellurium

Re: Custom query group issue

Hi,

We will need more details on what exactly are you looking for. The custom queries that are created in OpenManage Enterprise are based on the objects that are present in the OME db. Are you saying there should be a way to create just a CSV file outside of the appliance and then import it back? 

Thanks,
Pupul

0 Kudos
DELL-Pupul M
4 Tellurium

Re: Custom query group issue

Hi Andy,

I have been trying to replicate this problem for a while now but strangely i could not hit it. May be there is something else as well present in your appliance which is causing this to happen. Since it has been a while, were you able to sort this out?

Thanks,
Pupul

0 Kudos
cthoffman
1 Copper

Re: Custom query group issue

Long story short..........I'm a Dell engineer.  Large customer purchases servers through a partner.  Partner delivers servers in various sized batches.  10, 15, 25, even 50 at a time, along with a CSV of service tag and iDRAC MAC address.  Guy who manages OME wishes to not have to type in service tags manually in order to keep track of which servers of which delivery are now racked and ready to use.  He wants to keep each delivery as a separate custom group.

Your thoughts?

Thanks much.

Tags (3)
0 Kudos
DELL-Pupul M
4 Tellurium

Re: Custom query group issue

So let me put it this way. If there was a way to import these servers for discovery using CSV file such that the CSV file had the service tag and IP address of the server. And then there can be a group created based on the discovery job. Would this help?

Thanks,
Pupul

0 Kudos
Highlighted
cthoffman
1 Copper

Re: Custom query group issue

Service Tag and/or MAC address of iDRAC. IP address may not yet be assigned.
0 Kudos
DELL-Pupul M
4 Tellurium

Re: Custom query group issue

I am curious to understand how will you want to import the Service Tag and MAC address without discovering the server? Or are you saying keep the two mutually exclusive? Irrespective of what is present in the db, there should be a way to create a group. Is that correct?

Thanks,
Pupul

0 Kudos