public IList <IdNode> GetIdNodes()
{
IList <IdNode> nodes = new List <IdNode>();
using (EsentSession session = new EsentSession(_database))
{
session.Open();
JET_SESID sessionId = session.GetSessionId();
JET_DBID databaseId = session.GetDatabaseId();
JET_TABLEID tableId;
if (DatabaseTableExists(sessionId, databaseId, TABLE_DEVICES))
{
Api.OpenTable(sessionId, databaseId, TABLE_DEVICES, OpenTableGrbit.ReadOnly, out tableId);
Api.MoveBeforeFirst(session.GetSessionId(), tableId);
while (Api.TryMoveNext(sessionId, tableId))
{
IDictionary <string, JET_COLUMNID> columnDictionary = Api.GetColumnDictionary(sessionId, tableId);
IdNode node = new IdNode()
{
ConfigurationID = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ConfigurationID"]),
TargetName = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["TargetName"]),
NodeCompliant = Api.RetrieveColumnAsBoolean(sessionId, tableId, columnDictionary["NodeCompliant"]).GetValueOrDefault(),
Dirty = Api.RetrieveColumnAsBoolean(sessionId, tableId, columnDictionary["Dirty"]).GetValueOrDefault(),
LastHeartbeatTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["LastHeartbeatTime"]).GetValueOrDefault(),
LastComplianceTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["LastComplianceTime"]).GetValueOrDefault(),
StatusCode = Api.RetrieveColumnAsInt32(sessionId, tableId, columnDictionary["StatusCode"]).GetValueOrDefault(),
ServerCheckSum = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ServerCheckSum"]),
TargetCheckSum = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["TargetCheckSum"])
};
nodes.Add(node);
}
Api.JetCloseTable(sessionId, tableId);
}
else
{
_logger.Log(10091, String.Format("Database table {0} not found!", TABLE_DEVICES), LogLevel.Warning);
}
}
return(nodes);
}
public IList <NamesNode> GetNamesNodes()
{
IList <NamesNode> nodes = new List <NamesNode>();
using (EsentSession session = new EsentSession(_database))
{
session.Open();
JET_SESID sessionId = session.GetSessionId();
JET_DBID databaseId = session.GetDatabaseId();
JET_TABLEID tableId;
if (DatabaseTableExists(sessionId, databaseId, TABLE_REGISTRATION_DATA))
{
Api.OpenTable(sessionId, databaseId, TABLE_REGISTRATION_DATA, OpenTableGrbit.ReadOnly, out tableId);
Api.MoveBeforeFirst(session.GetSessionId(), tableId);
while (Api.TryMoveNext(sessionId, tableId))
{
IDictionary <string, JET_COLUMNID> columnDictionary = Api.GetColumnDictionary(sessionId, tableId);
NamesNode node = new NamesNode()
{
AgentId = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["AgentId"]),
NodeName = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["NodeName"]),
LCMVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["LCMVersion"]),
IPAddress = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["IPAddress"]),
ConfigurationNames = ((List <string>)Api.DeserializeObjectFromColumn(sessionId, tableId, columnDictionary["ConfigurationNames"]))
};
nodes.Add(node);
}
Api.JetCloseTable(sessionId, tableId);
}
else
{
_logger.Log(10091, String.Format("Database table {0} not found!", TABLE_REGISTRATION_DATA), LogLevel.Warning);
}
}
return(nodes);
}
public IList <Report> GetReports()
{
List <Report> reportsToReturn = new List <Report>();
List <Report> reportsInDatabase = new List <Report>();
using (EsentSession session = new EsentSession(_database)) {
session.Open();
JET_SESID sessionId = session.GetSessionId();
JET_DBID databaseId = session.GetDatabaseId();
JET_TABLEID tableId;
if (DatabaseTableExists(sessionId, databaseId, TABLE_STATUS_REPORT))
{
Api.OpenTable(sessionId, databaseId, TABLE_STATUS_REPORT, OpenTableGrbit.None, out tableId);
//Get all columns in the table
IDictionary <string, JET_COLUMNID> columnDictionary = Api.GetColumnDictionary(sessionId, tableId);
//Create a search index
if (Api.GetTableIndexes(sessionId, tableId).Any(index => index.Name == "EndTimeIndex") == false)
{
var indexKey = "+EndTime\0\0";
JET_INDEXCREATE startDateIndex = new JET_INDEXCREATE {
szKey = indexKey,
cbKey = indexKey.Length,
szIndexName = "EndTimeIndex",
};
Api.JetCreateIndex2(sessionId, tableId, new JET_INDEXCREATE[] { startDateIndex }, 1);
}
Api.JetSetCurrentIndex(sessionId, tableId, "EndTimeIndex");
//Create search keys.
Api.MakeKey(sessionId, tableId, DateTime.Now.AddHours(-2), MakeKeyGrbit.NewKey);
if (Api.TrySeek(sessionId, tableId, SeekGrbit.SeekGE))
{
do
{
Report reportRow = new Report()
{
Id = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["Id"]),
JobId = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["JobId"]),
NodeName = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["NodeName"]),
IPAddress = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["IPAddress"]),
RerfreshMode = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["RefreshMode"]),
OperationType = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["OperationType"]),
Status = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["Status"]),
RebootRequested = Api.RetrieveColumnAsBoolean(sessionId, tableId, columnDictionary["RebootRequested"]).GetValueOrDefault(),
StartTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["StartTime"]).GetValueOrDefault(),
EndTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["EndTime"]).GetValueOrDefault(),
LastModifiedTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["LastModifiedTime"]).GetValueOrDefault(),
LCMVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["LCMVersion"]),
ConfigurationVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ConfigurationVersion"]),
ReportFormatVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ReportFormatVersion"]),
Errors = (List <string>)Api.DeserializeObjectFromColumn(sessionId, tableId, columnDictionary["Errors"]),
};
List <string> statusDataList = (List <string>)Api.DeserializeObjectFromColumn(sessionId, tableId, columnDictionary["StatusData"]);
if (statusDataList.Count > 0)
{
reportRow.StatusData = statusDataList[0];
}
;
// Field AdditionalData is only available on WS2016 and WMF 5.1
if (columnDictionary.Keys.Contains("AdditionalData"))
{
reportRow.AdditionalData = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["AdditionalData"]);
}
reportsInDatabase.Add(reportRow);
} while (Api.TryMovePrevious(sessionId, tableId));
foreach (string node in GetNamesNodes().Select(node => node.NodeName).ToArray())
{
string NotCompliantResources = string.Empty;
string status = string.Empty;
Report latestReportForNode = reportsInDatabase.Where(r => r.NodeName == node).OrderByDescending(r => r.EndTime).First();
StatusDataElement dataElement = JsonConvert.DeserializeObject <StatusDataElement>(latestReportForNode.StatusData);
if (dataElement.ResourcesNotInDesiredState?.Count != null)
{
StringBuilder sb = new StringBuilder();
foreach (ResourceState resource in dataElement.ResourcesNotInDesiredState)
{
if (sb.Length != 0)
{
sb.Append(';');
sb.Append(resource.ResourceId);
}
else
{
sb.Append(resource.ResourceId);
}
}
latestReportForNode.NotCompliantResources = sb.ToString();
}
else
{
latestReportForNode.NotCompliantResources = string.Empty;
}
reportsToReturn.Add(latestReportForNode);
}
}
else
{
Report report = new Report()
{
Id = string.Empty,
JobId = string.Empty,
NodeName = null,
IPAddress = string.Empty,
RerfreshMode = string.Empty,
OperationType = string.Empty,
Status = "No status repot found for the last 2 hours!",
RebootRequested = false,
StartTime = null,
EndTime = null,
LastModifiedTime = null,
LCMVersion = string.Empty,
ConfigurationVersion = string.Empty,
ReportFormatVersion = string.Empty,
Errors = new List <string>()
{
string.Empty
},
StatusData = string.Empty,
NotCompliantResources = string.Empty
};
reportsToReturn.Add(report);
}
Api.JetCloseTable(sessionId, tableId);
}
else
{
_logger.Log(10091, String.Format("Database table {0} not found!", TABLE_STATUS_REPORT), LogLevel.Warning);
}
}
return(reportsToReturn.OrderBy(r => r.StartTime).ToList());
}
public IList <Report> GetReports()
{
List <Report> reports = new List <Report>();
using (EsentSession session = new EsentSession(_database))
{
session.Open();
JET_SESID sessionId = session.GetSessionId();
JET_DBID databaseId = session.GetDatabaseId();
JET_TABLEID tableId;
if (DatabaseTableExists(sessionId, databaseId, TABLE_STATUS_REPORT))
{
Api.OpenTable(sessionId, databaseId, TABLE_STATUS_REPORT, OpenTableGrbit.ReadOnly, out tableId);
Api.MoveBeforeFirst(session.GetSessionId(), tableId);
while (Api.TryMoveNext(sessionId, tableId))
{
IDictionary <string, JET_COLUMNID> columnDictionary = Api.GetColumnDictionary(sessionId, tableId);
Report report = new Report()
{
Id = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["Id"]),
JobId = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["JobId"]),
NodeName = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["NodeName"]),
IPAddress = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["IPAddress"]),
RerfreshMode = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["RefreshMode"]),
OperationType = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["OperationType"]),
Status = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["Status"]),
RebootRequested = Api.RetrieveColumnAsBoolean(sessionId, tableId, columnDictionary["RebootRequested"]).GetValueOrDefault(),
StartTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["StartTime"]).GetValueOrDefault(),
EndTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["EndTime"]).GetValueOrDefault(),
LastModifiedTime = Api.RetrieveColumnAsDateTime(sessionId, tableId, columnDictionary["LastModifiedTime"]).GetValueOrDefault(),
LCMVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["LCMVersion"]),
ConfigurationVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ConfigurationVersion"]),
ReportFormatVersion = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["ReportFormatVersion"]),
Errors = (List <string>)Api.DeserializeObjectFromColumn(sessionId, tableId, columnDictionary["Errors"]),
StatusData = (List <string>)Api.DeserializeObjectFromColumn(sessionId, tableId, columnDictionary["StatusData"])
};
// Field AdditionalData is only available on WS2016 and WMF 5.1
if (columnDictionary.Keys.Contains("AdditionalData"))
{
report.AdditionalData = Api.RetrieveColumnAsString(sessionId, tableId, columnDictionary["AdditionalData"]);
}
reports.Add(report);
}
Api.JetCloseTable(sessionId, tableId);
}
else
{
_logger.Log(10091, String.Format("Database table {0} not found!", TABLE_STATUS_REPORT), LogLevel.Warning);
}
}
return(reports.OrderBy(r => r.StartTime).ToList());
}