topic Re: How to Get Particular field from SCCM Data in Connectivity & Data Prep

How to Get Particular field from SCCM Data

akmalquamri — Thu, 11 Jan 2024 05:54:52 GMT

I have SQL Server view code and I need to fetch all fields from that particular view code in qlik sense script. Can anyone suggest detailed document for the same.

Re: How to Get Particular field from SCCM Data

Rohan — Thu, 11 Jan 2024 06:14:22 GMT

Hi Akmal,

Can you please explain your issue further ? Are you trying to fetch a sql db table into Qlik sense ? just create a connection with the db, & grant select rights to your qlik sense user to view the table in Qlik sense. You can then fetch the sql table(s) into Qlik sense.

Regards,

Rohan.

Re: How to Get Particular field from SCCM Data

akmalquamri — Thu, 11 Jan 2024 06:34:47 GMT

I have SCCM data source where some kind of SQL View code is written and to get some field I need to break those code in qlik.

Re: How to Get Particular field from SCCM Data

Anil_Babu_Samineni — Thu, 11 Jan 2024 06:35:07 GMT

@akmalquamri If I read your lebels you already have OLEDB, So Try to select data from connection and select the view that you need and Insert it?

Qlik will generate the script for you.

Or, LIB CONNECT TO 'Your Connection Name';

SQL Select * From <Your View Name with schema>;

Re: How to Get Particular field from SCCM Data

Rohan — Thu, 11 Jan 2024 06:44:58 GMT

Hi Akmal,

Check this article once if this is something that is related to your query :

https://community.qlik.com/t5/Connectivity-Data-Prep/Execute-stored-procedure-with-parameters/m-p/1627489#M4410

Regards,

Rohan.

Re: How to Get Particular field from SCCM Data

ZaniyahMercer — Thu, 08 Feb 2024 12:34:08 GMT

To start, head over to their SCCM integration section. There, you'll find step-by-step instructions and in-depth documentation on how to effectively integrate SCCM data into your Qlik Sense script. They often provide practical examples and troubleshooting tips to ensure a smooth data retrieval process.By leveraging the resources available on learnmesccm, you'll be well-equipped to tackle your data extraction needs and make the most of SCCM data within your Qlik Sense environment. Best of luck with your project, and don't hesitate to reach out if you have any more questions!