{"id":23,"date":"2009-08-18T15:05:00","date_gmt":"2009-08-18T13:05:00","guid":{"rendered":"\/post\/2009\/08\/18\/Retrieving-Agents-Sign-in-Information-in-RGS.aspx"},"modified":"2014-02-22T23:56:11","modified_gmt":"2014-02-22T22:56:11","slug":"retrieving-agents-sign-in-information-in-rgs","status":"publish","type":"post","link":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/","title":{"rendered":"Retrieving Agent&#8217;s Sign-in Information in RGS"},"content":{"rendered":"<p>Animated by a recent comment I decided to give some more insight into the Agent Sign-in logic of the Response Group Service of Office Communications Server 2007 R2.<\/p>\n<p>We keep the sign-in states of agents in formal agent groups in a dedicated table called &#8216;AgentGroupSignInStates&#8217; in the backend database (called &#8216;acddyn&#8217;) for each pool. The table is kept very simple. It consists only of three fields:<\/p>\n<ul>\n<li>AgentId (uniqueidentifier)<\/li>\n<li>GroupId (uniqueidentifier)<\/li>\n<li>State (tinyint)<\/li>\n<\/ul>\n<p>The first two fields, AgentId and GroupId, make up the primary key for the table, so they have to be unique. In other words, an agent can only have one sign-in state for every group he&#8217;s a member of. The State field indicates the current sign-in state for the agent with the given AgentId in the group with the given GroupId. A value of 0 means that the agent is not signed in, 1 means that the agent is signed in. If a record does not exist for an agent in a formal group, then the agent has never signed in yet (so he&#8217;s signed out). The AgentId and GroupId values should match the values of existing agents and groups in the RGS system (in WMI), though this is not enforced.<\/p>\n<p>You should not modify records in the &#8216;AgentGroupSignInStates&#8217; table, because the table is only kept as a reference in case of data-loss in the MatchMaking component of the Response Group Service. However, MatchMaking always keeps this table up-to-date, so reading from it should give you the most recent view on the sign-in states of the agents.<\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Animated by a recent comment I decided to give some more insight into the Agent Sign-in logic of the Response Group Service of Office Communications Server 2007 R2. We keep the sign-in states of agents in formal agent groups in a dedicated table called &#8216;AgentGroupSignInStates&#8217; in the backend database (called &#8216;acddyn&#8217;) for each pool. The &hellip; <a href=\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Retrieving Agent&#8217;s Sign-in Information in RGS&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[61],"tags":[41,32,34],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Retrieving Agent&#039;s Sign-in Information in RGS - Tales of a Code Monkey<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Retrieving Agent&#039;s Sign-in Information in RGS - Tales of a Code Monkey\" \/>\n<meta property=\"og:description\" content=\"Animated by a recent comment I decided to give some more insight into the Agent Sign-in logic of the Response Group Service of Office Communications Server 2007 R2. We keep the sign-in states of agents in formal agent groups in a dedicated table called &#8216;AgentGroupSignInStates&#8217; in the backend database (called &#8216;acddyn&#8217;) for each pool. The &hellip; Continue reading &quot;Retrieving Agent&#8217;s Sign-in Information in RGS&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\" \/>\n<meta property=\"og:site_name\" content=\"Tales of a Code Monkey\" \/>\n<meta property=\"article:published_time\" content=\"2009-08-18T13:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-02-22T22:56:11+00:00\" \/>\n<meta name=\"author\" content=\"roger\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"roger\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\",\"url\":\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\",\"name\":\"Retrieving Agent's Sign-in Information in RGS - Tales of a Code Monkey\",\"isPartOf\":{\"@id\":\"https:\/\/cymbeline.ch\/#website\"},\"datePublished\":\"2009-08-18T13:05:00+00:00\",\"dateModified\":\"2014-02-22T22:56:11+00:00\",\"author\":{\"@id\":\"https:\/\/cymbeline.ch\/#\/schema\/person\/cf1f3b3205f4266bf8b68a80fa6b0916\"},\"breadcrumb\":{\"@id\":\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cymbeline.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Retrieving Agent&#8217;s Sign-in Information in RGS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cymbeline.ch\/#website\",\"url\":\"https:\/\/cymbeline.ch\/\",\"name\":\"Tales of a Code Monkey\",\"description\":\"... the adventures of a guy making software.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cymbeline.ch\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/cymbeline.ch\/#\/schema\/person\/cf1f3b3205f4266bf8b68a80fa6b0916\",\"name\":\"roger\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cymbeline.ch\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/33cc08db99ae52beb26ab6fda46e0eb7?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/33cc08db99ae52beb26ab6fda46e0eb7?s=96&r=g\",\"caption\":\"roger\"},\"sameAs\":[\"https:\/\/www.cymbeline.ch\"],\"url\":\"https:\/\/cymbeline.ch\/author\/roger\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Retrieving Agent's Sign-in Information in RGS - Tales of a Code Monkey","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/","og_locale":"en_US","og_type":"article","og_title":"Retrieving Agent's Sign-in Information in RGS - Tales of a Code Monkey","og_description":"Animated by a recent comment I decided to give some more insight into the Agent Sign-in logic of the Response Group Service of Office Communications Server 2007 R2. We keep the sign-in states of agents in formal agent groups in a dedicated table called &#8216;AgentGroupSignInStates&#8217; in the backend database (called &#8216;acddyn&#8217;) for each pool. The &hellip; Continue reading \"Retrieving Agent&#8217;s Sign-in Information in RGS\"","og_url":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/","og_site_name":"Tales of a Code Monkey","article_published_time":"2009-08-18T13:05:00+00:00","article_modified_time":"2014-02-22T22:56:11+00:00","author":"roger","twitter_misc":{"Written by":"roger","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/","url":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/","name":"Retrieving Agent's Sign-in Information in RGS - Tales of a Code Monkey","isPartOf":{"@id":"https:\/\/cymbeline.ch\/#website"},"datePublished":"2009-08-18T13:05:00+00:00","dateModified":"2014-02-22T22:56:11+00:00","author":{"@id":"https:\/\/cymbeline.ch\/#\/schema\/person\/cf1f3b3205f4266bf8b68a80fa6b0916"},"breadcrumb":{"@id":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cymbeline.ch\/2009\/08\/18\/retrieving-agents-sign-in-information-in-rgs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cymbeline.ch\/"},{"@type":"ListItem","position":2,"name":"Retrieving Agent&#8217;s Sign-in Information in RGS"}]},{"@type":"WebSite","@id":"https:\/\/cymbeline.ch\/#website","url":"https:\/\/cymbeline.ch\/","name":"Tales of a Code Monkey","description":"... the adventures of a guy making software.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cymbeline.ch\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cymbeline.ch\/#\/schema\/person\/cf1f3b3205f4266bf8b68a80fa6b0916","name":"roger","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cymbeline.ch\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/33cc08db99ae52beb26ab6fda46e0eb7?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/33cc08db99ae52beb26ab6fda46e0eb7?s=96&r=g","caption":"roger"},"sameAs":["https:\/\/www.cymbeline.ch"],"url":"https:\/\/cymbeline.ch\/author\/roger\/"}]}},"_links":{"self":[{"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/posts\/23"}],"collection":[{"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":2,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":185,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/posts\/23\/revisions\/185"}],"wp:attachment":[{"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cymbeline.ch\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}