I have a list of 276 hostnames that I need to add to an existing report. Is there any other way (other than searching and adding one by one) to pass in an entire list of values to a filter?
Sep 04, 2020 04:11 PM
Depending on whether this is a recurring need and as such the effort involved you may want to look into adding the list of devices to a mashup data source, and as such be able to filter on "mashup group" membership in your reporting.
Sep 07, 2020 03:37 AM
Thanks for the suggestion. However, that would not work in this scenario. We have all of the end user Laptop, Desktop and Mobile device data being fed into BDNA/Data Platform from a specific data source. However, there is no easy way to filter the devices in BDNA based on a specific organization as there is no organization data in BDNA. I am currently populating a list of device hostnames from AD based on an organization filter and then trying to generate an EOL report based on the hostname list I have created from AD in BDNA. Creating 50+ separate data sources for each organization does not seem practical. Any other ideas?
Sep 14, 2020 10:41 AM
The idea was to use AD as a potential mashup data source in such scenario, did you look into documentation about Adding a Data Mashup to a Process ?
In this example three mashup data sources have been used so that reporting can be done by filtering, etc.:
Sep 15, 2020 01:21 AM - edited Sep 15, 2020 01:37 AM
I have looked at the Mashup documentation, several times in fact. The example is confusing to say the least. There are no linking "Objects" or "Mapping Fields" in either of the example csv files and the only identifiable correlation I can see is that the combined records are on the same row numbers on the originating csv files. Do you have a more specific example? Like for instance a sample .csv file with test data in it with the correct formatting?
I was able to generate a csv file with a dump of all the current data from AD, however I keep getting... "Object [Machine] does not support mapping field. Match key not found."...when I try to import it. The fields I have to work with are...
On a spreadsheet it would look like the following...
I can use a text editor to break up the "Description" into just the hostname or hostname and logged on date etc but the important data I need to keep is the User Name, User ID, Organization (either or both), and Hostname of the machine they logged into.
Any help would be greatly appreciated.
Sep 15, 2020 04:36 PM
Did you check the mashup examples in the IT Data Management Practice Guide ? (They were all tested before publishing...)
I'm also happy to send you a CSV file if that's helpful.
Sep 18, 2020 05:41 AM
Thanks for the document. I knew asking the community was a good idea. 🙂 I don't think I would have come across that document without your help. Question... when you are mashing up several different sources (in the example you have both AD and Organization) how are organization and AD linked together? Is it off of a User ID field? I am trying to link the already existing Hardware and Software information in BDNA to Active Directory Users and Organizations. Would I be correct in assuming that if I use the "HOSTNAME" as the "Key" in the mashup data that I would get the connection to Hardware, Software, Organization and Users?
Sep 23, 2020 09:19 AM
In my example both mashup data sources were independent and both linked to 'Machine' and as such enabled the reporting visualized in the screen shot.
It will depend on your data how you can create the relevant links for your reporting needs, but yes if you link to the Machine object somehow I think you'll be good (as I understand your use cases...)
Sep 24, 2020 07:08 AM
My mashup file must be incorrect. The only additional data I am getting in BDNA is user login information. I really need the Organization information so that I can report on what hardware and software from different organizations are end of life etc. Can anyone assist? Here is my current mashup format.
Key-Hostname:HOSTNAME Name UID Home Org Work Org EmailAddress SNUM
ID1234567 Smith, John A SMIJA A123 B456 John.Smith@inl.gov 000123
The only thing I can see that was added in Data Platform from the above example is the "SMIJA" user. All the other data doesn't seem accessible if it was imported.
Feb 24, 2021 10:41 AM
Please feel free to share a snippet of your data files with and I'll take a look. (I'll reach out to you personally...)
Feb 28, 2021 11:39 PM
Thanks John, I sent you an email.
Mar 08, 2021 10:40 AM