};
static char *gusl_fields[] = {
- "login",
+ "login", "domain_sid",
"login", "sid", "created",
};
};
static char *glsn_fields[] = {
- "name",
+ "name", "domain_sid",
"name", "sid", "created",
};
0,
};
+static char *gdds_fields[] = {
+ "sid",
+};
+
\f
/* Generalized Query Definitions */
"u.login, us.sid, TO_CHAR(us.created, 'YYYY-MM-DD HH24:MI:SS') FROM users u, usersids us",
gusl_fields,
3,
- "us.users_id = %d AND u.users_id = us.users_id",
- 1,
- "us.created",
+ "us.users_id = %d AND u.users_id = us.users_id AND SUBSTR(us.sid, 1, LENGTH(us.sid)-8) = '%s'",
+ 2,
+ NULL,
&gusl_validate,
},
"l.name, ls.sid, TO_CHAR(ls.created, 'YYYY-MM-DD HH24:MI:SS') FROM list l, listsids ls",
glsn_fields,
3,
- "ls.list_id = %d AND l.list_id = ls.list_id",
- 1,
- "created",
+ "ls.list_id = %d AND l.list_id = ls.list_id AND SUBSTR(ls.sid, 1, LENGTH(ls.sid)-8) = '%s'",
+ 2,
+ NULL,
&glsn_validate,
},
&alsn_validate,
},
+ {
+ /* Q_GDDS - GET_DISTINCT_DOMAIN_SIDS, v4 */
+ "get_distinct_domain_sids",
+ "gdds",
+ 4,
+ RETRIEVE,
+ "s",
+ USERSIDS_TABLE,
+ "DISTINCT SUBSTR(sid, 1, LENGTH(sid)-8) FROM usersids",
+ gdds_fields,
+ 1,
+ NULL,
+ 0,
+ NULL,
+ NULL,
+ },
+
};
int QueryCount = (sizeof(Queries) / sizeof(struct query));