<script runat="server"> | |
Platform.Load("Core", "1"); | |
try { | |
//initiate WSProxy | |
var prox = new Script.Util.WSProxy(); | |
//initiate data extension | |
var targetDE = 'xxxxxxx-xxxxxxx-xxxxxxxxx'; //pass external key of the target DE | |
var logDE = DataExtension.Init(targetDE); | |
function getImports(objectType, cols) { | |
var objectType = "ImportDefinition", | |
cols = ["DestinationObject.ObjectID", "Description", "Name", "ObjectID"], | |
moreData = true, | |
reqID = null, | |
numItems = 0; | |
while (moreData) { | |
moreData = false; | |
var data = reqID == null ? prox.retrieve(objectType, cols) : prox.getNextBatch(objectType, reqID); | |
if (data != null) { | |
moreData = data.HasMoreRows; | |
reqID = data.RequestID; | |
if (data && data.Results) { | |
for (var i = 0; i < data.Results.length; i++) { | |
if (data.Results[i].DestinationObject.ObjectID) { | |
var cols = ["Name", "CustomerKey", "ObjectID"]; | |
var filter = { | |
Property: "ObjectID", | |
SimpleOperator: "equals", | |
Value: data.Results[i].DestinationObject.ObjectID | |
}; | |
var deName = prox.retrieve("DataExtension", cols, filter); | |
if (deName.Results[0].Name) { | |
logDE.Rows.Add({ | |
DEName: deName.Results[0].Name, | |
DEKey: deName.Results[0].CustomerKey, | |
ActivityName: data.Results[i].Name, | |
ActivityType: "Import", | |
ActivityDescription: data.Results[i].Description | |
}); | |
} | |
} | |
numItems++; | |
} | |
} | |
} | |
} | |
Write("<br />" + numItems + " total " + objectType + "<br>"); | |
} | |
function getQueries(objectType, cols) { | |
var objectType = "QueryDefinition", | |
cols = ["Name", "Description", "ObjectID", "DataExtensionTarget.Name", "DataExtensionTarget.CustomerKey"], | |
moreData = true, | |
reqID = null, | |
numItems = 0; | |
while (moreData) { | |
moreData = false; | |
var data = reqID == null ? prox.retrieve(objectType, cols) : prox.getNextBatch(objectType, reqID); | |
if (data != null) { | |
moreData = data.HasMoreRows; | |
reqID = data.RequestID; | |
if (data && data.Results) { | |
for (var i = 0; i < data.Results.length; i++) { | |
logDE.Rows.Add({ | |
DEName: data.Results[i].DataExtensionTarget.Name, | |
DEKey: data.Results[i].DataExtensionTarget.CustomerKey, | |
ActivityName: data.Results[i].Name, | |
ActivityType: "Query", | |
ActivityDescription: data.Results[i].Description | |
}); | |
numItems++; | |
} | |
} | |
} | |
} | |
Write("<br />" + numItems + " total " + objectType + "<br>"); | |
} | |
getImports(objectType, cols) | |
getQueries(objectType, cols) | |
} catch (e) { | |
Write(Stringify(e)); | |
} | |
</script> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment