get-queries.js

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>");
	}