Posts made by dbenitez

dbenitez

@x16
You may want to look into Windows Unified Write Filter
If you don't have Windows Enterprise or Education, you can try looking into something like Faronics DeepFreeze

dbenitez

@theopenem_admin Wow, thank you for the quick response! The ability to write your own SQL query would be super helpful! I appreciate the fact that you're still adding features and responding to community posts. Looking forward to 1.5.7!

dbenitez

I want to create a dynamic group that has the effect of:

... WHERE Bios.serial_number IN ("ABC","123","Foo","Bar");

Dynamic Groups only allow for operators: =, !=,>,<,>=,<=,LIKE and NOT LIKE
You can string them together with OR or AND, which means the query would look something like:

... WHERE Bios.serial_number Like 'ABC' OR Bios.serial_number Like '123'...

With a long list of OR conditions.

But the UI forces multiple clicks per OR condition.

The problem is: what if I have like ~250 serials I want to include?

This would mean ~250 rows, with each needing multiple clicks to fill out the criteria.

With that being said, is it a bad idea to insert the criteria into the smart_group_queries table programmatically?

Some things I've tried/Considered

Things I've Tried/Considered	Why I ruled them out
Creating a static Group and programmatically adding memberships using SQL	If a computer gets a new ID or is a computer that hasn't been added to TOEM yet, I want the group to dynamically update
Entering dynamic criteria manually in the query builder	Time Consuming, prone to human error, soul-sucking?
Adding the `IN` operator manually in the operator field and a list in the value field of a row in smart_group_queries	This didn't seem to work. I tried a few combinations of quotes, no quotes, etc in the value field. Plus the UI handler really doesn't like it.

This leaves me with the remaining idea of adding the rows programmatically to smart_group_queries, but I wanted to see if anyone else had a better idea.

TLDR: I wanna programatically add dynamic criteria to smart_group_queries, but am hesitant to since it sounds like a dumb idea and was wondering if anyone had a better idea.

dbenitez

We're having a pretty hard time getting the imaging client to boot from a USB on new Latitude 5550s. So far, we noticed that their UEFI doesn't seem to have a fastboot option that can be set to thorough, like we've needed to do on most other dells. Does anyone know if the name of this setting was changed? When we try to get into the boot environment, it just freezes when initializing. All of the other common BIOS settings have been changed like secure boot and such.

dbenitez

@theopenem_admin Please don't misunderstand, I'm not trying to pressure or anything, just curious. By "next", Do you mean 1.5.7 or 2.0? I would imagine you're quite far into 1.5.7's development cycle.

dbenitez

@jason-cline Thank you for the info! It really does help put things into perspective.

dbenitez

Hello Theopenem community!
I've been looking into Theopenem for a few weeks and it seems like the perfect solution for our needs. I understand the application is highly scalable, but I read through the installation guide and I have three questions - (1) What does your environment look like (number of clients) and (2) what is your server configuration (Number of servers, OS, memory, storage, cpu type and # of cores) and (3) how well has that config served you given the size of your institution? Feel free to be as candid or reserved as you feel you need to be. I feel like this would help further adopters of this solution figure out if their server infrastructure is right as well.