<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="utf-8" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="LS" %>
<% Response.CacheControl = "no-cache";%>
<% Response.AddHeader("Pragma", "no-cache"); %>
<% Response.Expires = -1; %>
<% LS.User.Current().CheckWebsiteAccess(); %>
<%
var dsLocation = DB.ExecuteDataset("SELECT tsysIPLocations.StartIP, tsysIPLocations.EndIP, tsysIPLocations.IPLocation FROM tsysIPLocations;");
if (dsLocation.Rows.Count != 0)
{
foreach (DataRow myrowLocation in dsLocation.Rows)
{
%>
<%:myrowLocation["IPLocation"]%>
<% var dsAsset = DB.ExecuteDataset("SELECT OSCount.OS, OSCount.Servicepack, OSCount.Total, COALESCE (tsysOS.OSname, 'Win ' + OSCount.OS) AS Osname, COALESCE (tsysOS.Image, 'seven10.png') AS image FROM (SELECT COALESCE (tblAssets.SP, 0) AS Servicepack, COALESCE (tblAssets.OScode, '0') AS OS, COUNT(tblAssets.AssetID) AS Total FROM tblAssets INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID INNER JOIN tsysIPLocations ON tblAssets.IPNumeric Between tsysIPLocations.StartIP And tsysIPLocations.EndIP WHERE (tblAssets.Assettype = - 1) AND (tblAssetCustom.State = 1) AND (tsysIPLocations.IPLocation = '" + myrowLocation["IPLocation"] + "')GROUP BY COALESCE (tblAssets.SP, 0), COALESCE (tblAssets.OScode, '0')) OSCount LEFT OUTER JOIN tsysOS ON OSCount.OS = tsysOS.OScode ORDER BY COALESCE (tsysOS.Sortorder, 9999);");
int tel = 0;
if (dsAsset.Rows.Count != 0)
{%>
|
<% foreach (DataRow myrow in dsAsset.Rows)
{%>
<% } %>
|
|
<%}
}
}%>