Example #1
0
        public void Update(XEPosition pos)
        {
            var root = Registry.CurrentUser.OpenSubKey(KEY_PATH, RegistryKeyPermissionCheck.ReadWriteSubTree);
            var key = root.CreateSubKey(KEY_NODE, RegistryKeyPermissionCheck.ReadWriteSubTree);
            if (key == null) throw new UnauthorizedAccessException("Registry key not created. Please run the installer or create it manually");
            var trace = key.CreateSubKey(Trace);

            trace.SetValue(LASTFILE, pos.LastFile, RegistryValueKind.String);
            trace.SetValue(OFFSET, pos.Offset, RegistryValueKind.QWord);
        }
        public void CreateAndLoad()
        {
            RegistryStore prp = new RegistryStore("test2");

            var x = new XEPosition { LastFile = "MyLastFile", Offset = 2000 };

            prp.Update(x);

            var x2 = prp.Read();

            Assert.AreEqual(x, x2);
        }
Example #3
0
 public void CheckpointPosition(XEPosition pos)
 {
     Store.Update(pos);
 }
Example #4
0
        public List<XEPayload> GetLastEvents()
        {
            XEPosition pos;
            #region Read from registry
            try
            {
                pos = Store.Read();
            }
            catch (Exception)
            {
                pos = new XEPosition();
            }
            #endregion

            #region Data retrieval
            string sqlServerName;
            string sqlServerVersion;

            using (SqlCommand cmd = new SqlCommand("SELECT @@SERVERNAME, @@VERSION", this.DatabaseContext.Connection))
            {
                using (var reader = cmd.ExecuteReader())
                {
                    reader.Read();
                    sqlServerName = reader.GetString(0);
                    sqlServerVersion = reader.GetString(1);
                }
            }

            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection = this.DatabaseContext.Connection;
                cmd.CommandTimeout = 0;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "select * from sys.fn_xe_file_target_read_file(@path,null,@file,@offset) a";

                var pathParam = new SqlParameter("path", SqlDbType.NVarChar, 4000);
                pathParam.Value = XELPath;

                SqlParameter fileParam;
                if (pos.LastFile.Equals(String.Empty))
                {
                    fileParam = new SqlParameter("file", DBNull.Value);
                }
                else
                {
                    fileParam = new SqlParameter("file", pos.LastFile);
                }

                SqlParameter offsetParam;
                if (pos.Offset.Equals(0))
                {
                    offsetParam = new SqlParameter("offset", DBNull.Value);
                }
                else
                {
                    offsetParam = new SqlParameter("offset", pos.Offset);
                }

                cmd.Parameters.Add(pathParam);
                cmd.Parameters.Add(fileParam);
                cmd.Parameters.Add(offsetParam);
                List<XEPayload> payloads;

                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    payloads = ParsePayloads(reader);
                }

                foreach (XEPayload p in payloads)
                {
                    p.Dictionary[HT_SQL_SERVER_NAME] = sqlServerName;
                    p.Dictionary[HT_SQL_SERVER_VERSION] = sqlServerVersion;
                }

                return payloads;
            }
            #endregion
        }
Example #5
0
        protected static List<XEPayload> ParsePayloads(SqlDataReader reader)
        {
            List<XEPayload> payloads = new List<XEPayload>();

            while (reader.Read())
            {
                string eventName = reader.GetString(2);

                XEPosition posInner = new XEPosition()
                {
                    LastFile = reader.GetString(4),
                    Offset = reader.GetInt64(5)
                };

                XmlDocument doc = new XmlDocument();
                doc.LoadXml(reader["event_data"].ToString());
                DateTime eventTime = DateTime.Parse(doc.FirstChild.Attributes["timestamp"].Value);

                System.Collections.Generic.Dictionary<string, object> ht = new System.Collections.Generic.Dictionary<string, object>();

                foreach (XmlNode node in doc.SelectNodes("/event/data"))
                {
                    string name = node.Attributes["name"].Value;
                    string value = node.SelectSingleNode("value").InnerText;

                    AddTyped(ht, name, value);
                }

                foreach (XmlNode node in doc.SelectNodes("/event/action"))
                {
                    string name = string.Join("_", node.Attributes["package"].Value, node.Attributes["name"].Value);
                    string value = node.SelectSingleNode("value").InnerText;

                    AddTyped(ht, name, value);
                }

                ht[HT_NAME] = eventName;
                ht[HT_EVENT_TIME] = eventTime;

                payloads.Add(new XEPayload(ht, posInner));
            }

            return payloads;
        }