public override void ExtractData( string outputDirectory, CommonExtractionContext context, Dictionary<string, object> pluginSettings) { var collectorQueries = new CollectorQueries(); var collectionStatistics = new Dictionary<string, long>(); var resultSerializer = new SqlQueryResultSerializer( this.queryExecutor, context.SccmConnection, outputDirectory); foreach (QuerySettings query in collectorQueries.Queries) { long numberOfRows = resultSerializer.SerializeQueryResult( query.SelectionQuery, query.Name, null, (msg) => this.Notify(ExtractionStatus.Info, msg)); collectionStatistics.Add(query.Name, numberOfRows); } if (collectorQueries.Queries.Count > 0) { this.Notify(ExtractionStatus.Succeeded, "All query results collected successfully."); foreach (var stats in collectionStatistics) { this.Notify(ExtractionStatus.Info, string.Format("{0} {1} rows collected", stats.Key, stats.Value)); } } }
public override void ExtractData( string outputDirectory, CommonExtractionContext context, Dictionary <string, object> pluginSettings) { var collectorQueries = new CollectorQueries(); var collectionStatistics = new Dictionary <string, long>(); var resultSerializer = new SqlQueryResultSerializer( this.queryExecutor, context.SccmConnection, outputDirectory); foreach (QuerySettings query in collectorQueries.Queries) { long numberOfRows = resultSerializer.SerializeQueryResult( query.SelectionQuery, query.Name, null, (msg) => this.Notify(ExtractionStatus.Info, msg)); collectionStatistics.Add(query.Name, numberOfRows); } if (collectorQueries.Queries.Count > 0) { this.Notify(ExtractionStatus.Succeeded, "All query results collected successfully."); foreach (var stats in collectionStatistics) { this.Notify(ExtractionStatus.Info, string.Format("{0} {1} rows collected", stats.Key, stats.Value)); } } }