![]() ![]() i need all machines with mindmanager and mindjet but not the with the tag cst_MM_14_15 (they all have mindmanager or mindjet installed). You're right (thank you!) but i still have the problem with the SOFTWARE.DISPLAY_NAME not like '%cst_MM_14_15%'. perhaps you mean (SOFTWARE.DISPLAY_NAME like '%Mindmanager%'or SOFTWARE.DISPLAY_NAME like '%Mindjet%') You get wrong results? I'm surprised you get any results at all, since your query has a syntax error: where(SOFTWARE.DISPLAY_NAME like '%Mindmanager%'or '%Mindjet%')is not valid SQL. How can solve that? Tia!select MACHINE.NAME, SOFTWARE.DISPLAY_NAME, MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE as 'OS Language'from MACHINE left join MACHINE_CUSTOM_INVENTORY ON MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID left join MACHINE_SOFTWARE_JT ON MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID left join SOFTWARE ON SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_IDwhere (SOFTWARE.DISPLAY_NAME like '%Mindmanager%' or '%Mindjet%') and (MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE = '0409' or MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE = '0407') and (SOFTWARE.DISPLAY_NAME not like '%cst_MM_14_15%')order by MACHINE.NAME The tag also uses SOFTWARE.DISPLAY_NAME and I get “wrong” results. I need all machines with the software mindmanager, code 0409 or 0407 but not with the tag cst_MM_14_15. ![]() We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |