Hi everyone,
Due to the nature of where I work, I can't upload a workbook, but I'm hoping the community can help anyway. I'm using latest 2019.2 Tableau Desktop, and am not quite sure how to go about doing this. I can say that the two data sources I'm using are Microsoft's System Center Config. Manager (SCCM) and Titus Software's Classification Suite. (Two distinct SQL Databases). Basically, my boss has asked me to see which computers either don't have Titus on them at all, or which ones have Titus installed, but are not working. The way I've started to think about this is, SCCM can tell me every computer we have, and all the software installed on it. Titus DB is basically an event log, so I can tell which computers are reporting into it. I am having trouble getting the difference.
So far, I've loaded the ProductName (SCCM data that has software title) field into filters and checked every box for Titus and then checked the Exclude box. I then loaded the ComputerName field into Rows, and it still shows everything. I thought that it would exclude those machines with those titles in it.
I'm going to keep trying some other ways to get this, but I was hoping someone out in the community may have done something similar. If I figure it out prior to getting an answer, I'll post what works, so that it could potentially help someone else in future.
Thanks,
Tom
Hi Tom,
Upfront I made quite some assumptions;) but find my approach as reference below and stored in attached workbook version 10.5 located in your original post here:
Trying to get list of computers that DON'T have a software title on them
1. SCCM-database
2. Titus-database
3. join
4. 01 D Display: contains([Product Name],'Titus')
5. 01 D Reporting/No Reporting: if isnull([ComputerName (Titus)])=False then "Titus installed & Reporting" else "Titus installed but no Reporting" END
6. Drag the required calculated fields to the indicated locations and filter 01 D Display on True
Thanks,
Norbert
