Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Syndicate_Admin
Administrator
Administrator

Generate spiceworks Tickets report

Hello I annoy you because I need to generate a list of incidents uploaded to the spiceworks cloud system and indicates that to generate lists and reports recommends using Power BI.

Additional fields called address, incidente_origen, etc. were generated to the spiceworks help desk structures.

There are 6 custom fields.

I now have 13 tickets uploaded and in the tickets detail table there are 13 records. In the custom attribute tickets table generate a record for each Custo Field and there are more than 30 re. This is seen in the first image.que attached.

Now I do not know how to generate a report that in the same line puts all the information corresponding to the same ticket. The second image is seen.

Can you help me?

D

caso1.jpgcaso1a.jpg

3 REPLIES 3
tjbennett
New Member

I am looking to have a Spiceworks Ticket report that shows the ticket (and description) with the comments pertaining to that ticket indented under it. Has anyone come up with a smilar report?

aallanaok
Regular Visitor

Hello Caitlyn Yan, thank you for answering my question. In the attached image you can see that the lines are repeated for each number of tickets. just changing the information in the "Ticket Custom Attributes" table. The tables are unit by the ticket number but I can't do to see all the information in the same line. I don't know if I was clear in my explanation? caso1b.jpg

v-xiaoyan-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

 

I'm not sure I've understood your needs accurately.
Do you expect the output to be like the second picture?

You can try to create this list by using table visual and dragging all the required fields into this visual.

 

If I have not understood your needs correctly, please do not hesitate to inform me.


Hope it helps,


Community Support Team _ Caitlyn Yan


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.