Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Can you link a MS SQL db to sql lite?

mcgregor.chris

January 20, 2021 07:58

I would like to link a view in another database to a registry value I am pulling for machines into inventory so that my PDQ reporting can show things such as the users department and team in report. Is it possible to link and SQL database or perhaps Creator join in the SQL query of advanced report?

Comments

2 comments

Lipovsky, Marcel
January 30, 2021 02:19

Hi Chris, do you mean it like inter-process communication via registry or SQL?
In theory, the PowerShell scanner could do that, but I don't have enough experience with that to create a sample.

1
mcgregor.chris
February 01, 2021 01:30

Hey SelfMan,

Sorry, rereading my question it is worded a little weird.

To clean up the question a little:

Can I join a MS SQL table to a PDQ Report?

I have a MS SQL database hosting our payroll data that includes the company structure and would like to get that information to add to a SQL report in PDQ.

I have had a little experience recently with using powershell to get data from the SQLlite that hosts the PDQ database and pushing that data back into custom fields. So i'll take your advice and have a bit of a look to see how much is involved with connecting powershell to MSSQL and then importing that data into the PDQ DB also.

Thank you :)

0