Hi Kumar.
Although I have some of the ArcGIS for Server software installed, we have not yet begun the long and arduous journey to migrating to a webserver (which, as far as I understand it, is required to use workflow manager and other ArcGIS for server features), so for now, I am just working with SQLServer 2008r2 and ArcGIS version10.2.2 for desktop. To answer your questions:
1-
ArcGIS 10.2.2 for Desktop
ArcGIS 10.2.2 License Manager
Esri Production Mapping 10.2.2
Esri Defense Mapping 10.2.2
ArcGIS 10.2.2 Data Reviewer for Desktop
ArcSDE 10.2.2 for Microsoft SQL Server
ArcGIS 10.2.2 for Server
ArcGIS 10.2.2 Workflow Manager for Server
ArcGIS 10.2.2 Data Reviewer for Server
2 - Yes. I am just remapping the work-space location so that the same checks will be valid to run on multiple different databases.
I realize this is not the case, but ideally I would like to: 1 - create one set of checks in a master RBJ file 2- pick which databases the checks get ran on and 3 - just specify the session (or even a different database for that matter) that each database's results get put into.
3 - Yes. At minimum, if each cell's results would be written to different sessions, then the analyst responsible for that cell will be able to just connect to the reviewer database (an sde database) and see the check results for their area only (since each session will be unique to each cell). I have it set to only run on changed features, so every day, only new results are added to the table.
But as it sits, I can set one reviewer work-space, that writes to one session, that uses checks that have to specify what database they are to be run on. Database. Not Databases. So, as a simple example. if I want to check make sure none of the buildings in my databases have an ARA = 12, then I have to write that in an RBJ file for database one. Then I have to duplicate that RBJ and change the database it's mapped to to database2. And so on. And that would be okay, but from there all I can do is import all of those checks into the configuration. But now what? Where does that leave me?
It leaves me in one of two places.
I can either load all the checks for all the databases and have the service run that once. But that just shoves all of the data into one session that people have to sort through and is separated geographically by vasts swaths of earth and man-made boundary.
OR
I can load the RBJ that's mapped to area1 only and set that to either a different datareviewer workspace or a different session. doesn't matter. Then I could create a configuration file with just the checks that are mapped to area2 and set that to either a different datareviewer workspace or a different session. doesn't matter. . BUT the service controller only allows one configuration file at a time. So unless I only want it to run on AREA1 every day, I have to wait for it to run area1's configuration. Then change the configuration to Area2's configuration. Manually restart the service. Wait for it to run on area2. Change the config to AreaX. restart service...and so on.
Which, at that level of manual over-site, you'd just be better off running the process in ArcMap because it's as or more labor intensive.
I hope this has helped you gain a clearer picture of my issue. Do not hesitate to ask for more information.