cmdb

I am stuck in the middle of trying to write a SQL query that leverages multiple joins for tables that are only related through many-to-many mappings. I cannot alter any of the table structures and I cannot add any more relation rows in the mapping tables, so what they've given me is all I have to work with.

I realize there are several questions in here about duplicate rows in many-to-many queries, but I think this one is slightly different because I want to allow duplicates, but only from the first set of joins.

This is part of a CMDB application, and the relationships do work in real life because the GUI can correctly display the related data. Unfortunately, my SQL knowledge is nowhere near bordering proficient so I’d like to reach out to you all for help.

Here are my tables:

Circuits:

I'm using a MS Access query to import records from SCCM to Service-Now (which is called CMDB in my Access database) through an Excel file. I have to set the Active field in Service-Now to 'TRUE'. There is an Active field in the CMDB extract inside the Access database, called CMDB.Active. I would like to set the value of this field to always 'TRUE' regardless of the existing value (I don't always import records, sometimes update them based on the last usage). In order to set CMDB.Active always to TRUE, I converted the field to a calculated field: '"TRUE" AS Active'. In Design View and also when I export the query, it is displayed as TRUE, however, when I upload the Excel loading sheet to Service-Now, the format of the Active field is not recognized somehow and the Active field is left as FALSE after uploading the loading sheet. However, when I don't convert the Active.CMDB field to a calculated field, but manually change the FALSE values in the Excel loading sheet from FALSE or empty to TRUE, then Service-Now recognizes the format.

I tried to change the format of the Active field to True\False, but it didn't help. When the Excel loading sheet contained 'True' as value, Service-Now didn't accept it, because it requires 'TRUE'. Maybe I was using the Format function in the wrong way?

I am trying to call a python function from another script in a different directory. Have a playbook to execute this.

This works fine on localhost but on remote_server it is failing with "ModuleNotFoundError: No module named 'script2'"

I want to create multiple CSV file for every drop down Selected value. Even-though while debugging i can notice csv is appending for different drop down value but not writing another CSV file. do not know why and where i am doing mistake.

When i remove using block, and for second time its throwing error :

Situation: I am getting an issue when trying to load a basic dynamic inventory python file in Ansible.
Background: When I perform python test.py it will output the list however in ansible it fails
Assessment: I have tried lots of other example files and none have worked, this is the simplest i could make it
Recommendation: Can someone please point me in the right direction? is this to do with the ansible.cfg?

I'm looking for the right SQL request. I'm using SQLite.

I have one principal table "cmdb":

I am trying to take the results from some questionnaire, the results are then sent to some API to be scored and results are returned, upon successful return of the results they are saved as an object to the Entity.

Here is my code: (Non-important data replaced with stars)

I'm having a problem accessing a nested Set of objects. I have defined the below objects :

experts, i want to perform vlookup between two excels with two different column names and output column name also to be differnt.

Lets take below example to understand scenario In source excel file1 I am having column name as "Computer name" at position A, In source excel file2 I am also having column name as "short" at position B. I want to perform vlookup(a kind of left join of sql) between excel file1's "Computer name" column and excel file2's and "short" column. After vlookup i want to add output of vlookup in excel file1 as cloumn name as "CMDB crosscheck" which is at position B in screen print shown below of final output excel file. Please note that rest all columns of excel file1 will remain there, just new column will take place position B in excel file1

Source Excel file1:

Source Excel file2:

Output excel file:

I am using below code but its not working. requset you to please suggest