Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
akmalquamri
Contributor III
Contributor III

How to Get Particular field from SCCM Data

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.

 

Labels (2)
1 Solution

Accepted Solutions
Rohan
Specialist
Specialist

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/16...

Regards,

Rohan.

View solution in original post

5 Replies
Rohan
Specialist
Specialist

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.

akmalquamri
Contributor III
Contributor III
Author

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.

Anil_Babu_Samineni

@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>;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Rohan
Specialist
Specialist

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/16...

Regards,

Rohan.

ZaniyahMercer
Contributor
Contributor

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!