function getQueries(objectType, cols) { | |
var prox = new Script.Util.WSProxy(), | |
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>"); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment