Coatse asked a question.
Show printer in Show all computers view
Hi,
Does anyone know if we can put the column on the View all computers screen to show the Default printer.
James
- Community Manager (Flexera Software)Hi James, overview listings can be personalized using the column selector in the upper right corner of the screen. You can select various columns that will then show up. Unfortunately the 'default printer' column can't be chosen. You can log an idea at our Snow Ideas Board if you would like to see this feature in the product. A custom solution for your request would be a custom report that you can add by yourself. First you would need a SQL query that shows the content you would like to see in Snow License Manager (e.g. computer hostname | default printer name). For implementation please stick to this very useful guide . A very basic solution would be: select c . ComputerID, c . HostName, cp. PrinterName, cp. IsDefault from tblComputer c left join tblComputerPrinters cp on c . ComputerID = cp. ComputerID This would give you the following result: If you have further questions please let us know! /marcelExpand Post
- Community Manager (Flexera Software)You could then further develop this query by adding one line: select c . ComputerID, c . HostName, cp. PrinterName, cp. IsDefault from tblComputer c left join tblComputerPrinters cp on c . ComputerID = cp. ComputerID where cp. PrinterName is not and cp. IsDefault = '1' This would then only show computers with set default printers. /marcelExpand Post
- Coatse Is this possible in a report? JamesExpand Post
