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);
}
public void CheckpointPosition(XEPosition pos)
{
Store.Update(pos);
}
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
}
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;
}