wsproxy-import-query.html

<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>