Thanks John, I sent you an email. ... View more

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.   Thanks, ... View more

Hey John, 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?   Thanks,   Matt ... View more

Hi John, 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... CN: = "LastName, FirstName (USERID)" Department: = "Base Organization Number" Division: = "Work Organization Number" EmailAddress: = first.last@inl.gov Description: = last,first (USERID) logged onto HOSTNAME at 9/15/2020 1:13:31pm.  On a spreadsheet it would look like the following... CN                        Department    Division   EmailAddress                    Description Rogers, Fred     0000                   0000         fred.rogers@inl.gov        Rogers, Fred   (ROGFR) logged onto HST123456 at 9/15/2020 1:13:31pm 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.   Thanks, ... View more

Hi John,   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?   Thanks, ... View more