I do have a call in to Sales and they are going to get back to me on this subject but I thought I would ask the community too.
I'm coming to a decision point whether to purchase DIAdem or use some other method (SQL, VBA) to glean some data from my TestStand results databases.
First I'm a database neophyte but I am tasked to query some data from the ATE systems that write their results to Jet 4.0 (Access) databases using the TestStand 2010 sp1 Generic Insert (GI 2.x-4.0) schema.
Each ATE has it's own results DB so I would need to deal with each one separately. I know the data I am asking for is in those databases.
Basically I was asked to determine how many operators used the ATE's, how many total sequences were run per year, and how much total time was spent (per year) running sequences.
I could take the time to learn VBA and query for the data and total it up in, let's say a Excel spreadsheet. I could take the time to learn SQL and do the same thing or I could spend my time learning DIAdem scripting. Either way I am going to have a learning curve ahead of me.
Any thoughts or comments are welcome.
I was surprised to learn that Diadem does not ship with a plugin for Teststand database schemas, it seems like NI are missing out on something here. So yes, it seems you are stuck with other SQL tools.
For clarity they do have a dataplugin for .mdb databases. The problem I noted is that it requires
DataFinder Server Edition 1.1.1. which is another paid for toolkit. After talking with several folks at NI it turns out they changed the .SQL plugin so that can be used on a .MDB database. After careful consideration I've decided that DIAdem was a bit overkill for the data I want to analyse and I'm going a different route.
>> Basically I was asked to determine how many operators used the ATE's
SELECT DISTINCT(USER_LOGIN_NAME) FROM UUT_RESULT
>> how many total sequences were run per year, and how much total time was spent (per year) running sequences
SELECT Test_Year, COUNT(ID) AS Num_Tested, SUM(EXECUTION_TIME) AS Sum_Time FROM (SELECT ID, YEAR(START_DATE_TIME) AS Test_Year, EXECUTION_TIME FROM UUT_RESULT) GROUP BY Test_Year
It looks like you only want the data from one of the tables, so it might be a smaller task than you're thinking.